﻿<?xml version="1.0" encoding="utf-8"?>
<xs:schema id="dsMovimiento" targetNamespace="http://tempuri.org/dsMovimiento.xsd" xmlns:mstns="http://tempuri.org/dsMovimiento.xsd" xmlns="http://tempuri.org/dsMovimiento.xsd" xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:msdata="urn:schemas-microsoft-com:xml-msdata" xmlns:msprop="urn:schemas-microsoft-com:xml-msprop" attributeFormDefault="qualified" elementFormDefault="qualified">
  <xs:annotation>
    <xs:appinfo source="urn:schemas-microsoft-com:xml-msdatasource">
      <DataSource DefaultConnectionIndex="1" FunctionsComponentName="QueriesTableAdapter" Modifier="AutoLayout, AnsiClass, Class, Public" SchemaSerializationMode="IncludeSchema" xmlns="urn:schemas-microsoft-com:xml-msdatasource">
        <Connections>
          <Connection AppSettingsObjectName="MySettings" AppSettingsPropertyName="ConnectionString" ConnectionStringObject="" IsAppSettingsProperty="true" Modifier="Assembly" Name="ConnectionString (MySettings)" ParameterPrefix=":" PropertyReference="ApplicationSettings.lbGlobalcom.My.MySettings.GlobalReference.Default.ConnectionString" Provider="Oracle.DataAccess.Client" />
          <Connection AppSettingsObjectName="MySettings" AppSettingsPropertyName="ConnectionString1" IsAppSettingsProperty="true" Modifier="Assembly" Name="ConnectionString1 (MySettings)" ParameterPrefix=":" PropertyReference="ApplicationSettings.lbGlobalcom.My.MySettings.GlobalReference.Default.ConnectionString1" Provider="Oracle.DataAccess.Client" />
        </Connections>
        <Tables>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="MOV_MOVIMIENTOTableAdapter" GeneratorDataComponentClassName="MOV_MOVIMIENTOTableAdapter" Name="MOV_MOVIMIENTO" UserDataComponentName="MOV_MOVIMIENTOTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="ConnectionString (MySettings)" DbObjectName="SAMUEL.MOV_MOVIMIENTO" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM "MOV_MOVIMIENTO" WHERE (("IDDOCUMENTO" = :Original_IDDOCUMENTO) AND ("NUMERO" = :Original_NUMERO) AND ((:IsNull_ANULADO = 1 AND "ANULADO" IS NULL) OR ("ANULADO" = :Original_ANULADO)) AND ((:IsNull_FECHADOCUMENTO = 1 AND "FECHADOCUMENTO" IS NULL) OR ("FECHADOCUMENTO" = :Original_FECHADOCUMENTO)) AND ((:IsNull_FECHAVENCIMIENTO = 1 AND "FECHAVENCIMIENTO" IS NULL) OR ("FECHAVENCIMIENTO" = :Original_FECHAVENCIMIENTO)) AND ((:IsNull_IDBODEGADESTINO = 1 AND "IDBODEGADESTINO" IS NULL) OR ("IDBODEGADESTINO" = :Original_IDBODEGADESTINO)) AND ((:IsNull_IDBODEGAORIGEN = 1 AND "IDBODEGAORIGEN" IS NULL) OR ("IDBODEGAORIGEN" = :Original_IDBODEGAORIGEN)) AND ((:IsNull_IDCANAL = 1 AND "IDCANAL" IS NULL) OR ("IDCANAL" = :Original_IDCANAL)) AND ((:IsNull_IDCCOSTO = 1 AND "IDCCOSTO" IS NULL) OR ("IDCCOSTO" = :Original_IDCCOSTO)) AND ((:IsNull_IDDOCREFERENCIA = 1 AND "IDDOCREFERENCIA" IS NULL) OR ("IDDOCREFERENCIA" = :Original_IDDOCREFERENCIA)) AND ((:IsNull_IDLISTA = 1 AND "IDLISTA" IS NULL) OR ("IDLISTA" = :Original_IDLISTA)) AND ((:IsNull_IDSEDE = 1 AND "IDSEDE" IS NULL) OR ("IDSEDE" = :Original_IDSEDE)) AND ((:IsNull_IDTERCERO = 1 AND "IDTERCERO" IS NULL) OR ("IDTERCERO" = :Original_IDTERCERO)) AND ((:IsNull_IDVENDEDOR = 1 AND "IDVENDEDOR" IS NULL) OR ("IDVENDEDOR" = :Original_IDVENDEDOR)) AND ((:IsNull_IMPRESO = 1 AND "IMPRESO" IS NULL) OR ("IMPRESO" = :Original_IMPRESO)) AND ((:IsNull_NOTA = 1 AND "NOTA" IS NULL) OR ("NOTA" = :Original_NOTA)) AND ((:IsNull_NUMEROREFERENCIA = 1 AND "NUMEROREFERENCIA" IS NULL) OR ("NUMEROREFERENCIA" = :Original_NUMEROREFERENCIA)) AND ((:IsNull_SALDO = 1 AND "SALDO" IS NULL) OR ("SALDO" = :Original_SALDO)) AND ((:IsNull_VALORBASE = 1 AND "VALORBASE" IS NULL) OR ("VALORBASE" = :Original_VALORBASE)) AND ((:IsNull_VALORIVA = 1 AND "VALORIVA" IS NULL) OR ("VALORIVA" = :Original_VALORIVA)) AND ((:IsNull_VALORPAGOS = 1 AND "VALORPAGOS" IS NULL) OR ("VALORPAGOS" = :Original_VALORPAGOS)) AND ((:IsNull_VALORRETENCION = 1 AND "VALORRETENCION" IS NULL) OR ("VALORRETENCION" = :Original_VALORRETENCION)) AND ((:IsNull_SUCURSAL = 1 AND "SUCURSAL" IS NULL) OR ("SUCURSAL" = :Original_SUCURSAL)) AND ((:IsNull_IDFORMAPAGO = 1 AND "IDFORMAPAGO" IS NULL) OR ("IDFORMAPAGO" = :Original_IDFORMAPAGO)) AND ((:IsNull_NOFACCOMCEL = 1 AND "NOFACCOMCEL" IS NULL) OR ("NOFACCOMCEL" = :Original_NOFACCOMCEL)) AND ((:IsNull_IDCAJA = 1 AND "IDCAJA" IS NULL) OR ("IDCAJA" = :Original_IDCAJA)) AND ((:IsNull_IDCENTROSUMI = 1 AND "IDCENTROSUMI" IS NULL) OR ("IDCENTROSUMI" = :Original_IDCENTROSUMI)) AND ((:IsNull_NOREMCOMCEL = 1 AND "NOREMCOMCEL" IS NULL) OR ("NOREMCOMCEL" = :Original_NOREMCOMCEL)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_IDDOCUMENTO" Precision="0" ProviderType="Varchar2" Scale="0" Size="5" SourceColumn="IDDOCUMENTO" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="Original_NUMERO" Precision="0" ProviderType="Decimal" Scale="0" Size="22" SourceColumn="NUMERO" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_ANULADO" Precision="0" ProviderType="Int32" Scale="0" Size="1" SourceColumn="ANULADO" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="Original_ANULADO" Precision="0" ProviderType="Char" Scale="0" Size="1" SourceColumn="ANULADO" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_FECHADOCUMENTO" Precision="0" ProviderType="Int32" Scale="0" Size="7" SourceColumn="FECHADOCUMENTO" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Date" Direction="Input" ParameterName="Original_FECHADOCUMENTO" Precision="0" ProviderType="Date" Scale="0" Size="7" SourceColumn="FECHADOCUMENTO" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_FECHAVENCIMIENTO" Precision="0" ProviderType="Int32" Scale="0" Size="7" SourceColumn="FECHAVENCIMIENTO" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Date" Direction="Input" ParameterName="Original_FECHAVENCIMIENTO" Precision="0" ProviderType="Date" Scale="0" Size="7" SourceColumn="FECHAVENCIMIENTO" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_IDBODEGADESTINO" Precision="0" ProviderType="Int32" Scale="0" Size="5" SourceColumn="IDBODEGADESTINO" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_IDBODEGADESTINO" Precision="0" ProviderType="Varchar2" Scale="0" Size="5" SourceColumn="IDBODEGADESTINO" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_IDBODEGAORIGEN" Precision="0" ProviderType="Int32" Scale="0" Size="5" SourceColumn="IDBODEGAORIGEN" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_IDBODEGAORIGEN" Precision="0" ProviderType="Varchar2" Scale="0" Size="5" SourceColumn="IDBODEGAORIGEN" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_IDCANAL" Precision="0" ProviderType="Int32" Scale="0" Size="5" SourceColumn="IDCANAL" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_IDCANAL" Precision="0" ProviderType="Varchar2" Scale="0" Size="5" SourceColumn="IDCANAL" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_IDCCOSTO" Precision="0" ProviderType="Int32" Scale="0" Size="5" SourceColumn="IDCCOSTO" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_IDCCOSTO" Precision="0" ProviderType="Varchar2" Scale="0" Size="5" SourceColumn="IDCCOSTO" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_IDDOCREFERENCIA" Precision="0" ProviderType="Int32" Scale="0" Size="5" SourceColumn="IDDOCREFERENCIA" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_IDDOCREFERENCIA" Precision="0" ProviderType="Varchar2" Scale="0" Size="5" SourceColumn="IDDOCREFERENCIA" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_IDLISTA" Precision="0" ProviderType="Int32" Scale="0" Size="5" SourceColumn="IDLISTA" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_IDLISTA" Precision="0" ProviderType="Varchar2" Scale="0" Size="5" SourceColumn="IDLISTA" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_IDSEDE" Precision="0" ProviderType="Int32" Scale="0" Size="5" SourceColumn="IDSEDE" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_IDSEDE" Precision="0" ProviderType="Varchar2" Scale="0" Size="5" SourceColumn="IDSEDE" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_IDTERCERO" Precision="0" ProviderType="Int32" Scale="0" Size="15" SourceColumn="IDTERCERO" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_IDTERCERO" Precision="0" ProviderType="Varchar2" Scale="0" Size="15" SourceColumn="IDTERCERO" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_IDVENDEDOR" Precision="0" ProviderType="Int32" Scale="0" Size="15" SourceColumn="IDVENDEDOR" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_IDVENDEDOR" Precision="0" ProviderType="Varchar2" Scale="0" Size="15" SourceColumn="IDVENDEDOR" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_IMPRESO" Precision="0" ProviderType="Int32" Scale="0" Size="1" SourceColumn="IMPRESO" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="Original_IMPRESO" Precision="0" ProviderType="Char" Scale="0" Size="1" SourceColumn="IMPRESO" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_NOTA" Precision="0" ProviderType="Int32" Scale="0" Size="150" SourceColumn="NOTA" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_NOTA" Precision="0" ProviderType="Varchar2" Scale="0" Size="150" SourceColumn="NOTA" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_NUMEROREFERENCIA" Precision="0" ProviderType="Int32" Scale="0" Size="22" SourceColumn="NUMEROREFERENCIA" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="Original_NUMEROREFERENCIA" Precision="0" ProviderType="Decimal" Scale="0" Size="22" SourceColumn="NUMEROREFERENCIA" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_SALDO" Precision="0" ProviderType="Int32" Scale="0" Size="22" SourceColumn="SALDO" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="Original_SALDO" Precision="0" ProviderType="Decimal" Scale="0" Size="22" SourceColumn="SALDO" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_VALORBASE" Precision="0" ProviderType="Int32" Scale="0" Size="22" SourceColumn="VALORBASE" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="Original_VALORBASE" Precision="0" ProviderType="Decimal" Scale="0" Size="22" SourceColumn="VALORBASE" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_VALORIVA" Precision="0" ProviderType="Int32" Scale="0" Size="22" SourceColumn="VALORIVA" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="Original_VALORIVA" Precision="0" ProviderType="Decimal" Scale="0" Size="22" SourceColumn="VALORIVA" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_VALORPAGOS" Precision="0" ProviderType="Int32" Scale="0" Size="22" SourceColumn="VALORPAGOS" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="Original_VALORPAGOS" Precision="0" ProviderType="Decimal" Scale="0" Size="22" SourceColumn="VALORPAGOS" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_VALORRETENCION" Precision="0" ProviderType="Int32" Scale="0" Size="22" SourceColumn="VALORRETENCION" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="Original_VALORRETENCION" Precision="0" ProviderType="Decimal" Scale="0" Size="22" SourceColumn="VALORRETENCION" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_SUCURSAL" Precision="0" ProviderType="Int32" Scale="0" Size="22" SourceColumn="SUCURSAL" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="Original_SUCURSAL" Precision="0" ProviderType="Decimal" Scale="0" Size="22" SourceColumn="SUCURSAL" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_IDFORMAPAGO" Precision="0" ProviderType="Int32" Scale="0" Size="5" SourceColumn="IDFORMAPAGO" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_IDFORMAPAGO" Precision="0" ProviderType="Varchar2" Scale="0" Size="5" SourceColumn="IDFORMAPAGO" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_NOFACCOMCEL" Precision="0" ProviderType="Int32" Scale="0" Size="15" SourceColumn="NOFACCOMCEL" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_NOFACCOMCEL" Precision="0" ProviderType="Varchar2" Scale="0" Size="15" SourceColumn="NOFACCOMCEL" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_IDCAJA" Precision="0" ProviderType="Int32" Scale="0" Size="3" SourceColumn="IDCAJA" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_IDCAJA" Precision="0" ProviderType="Varchar2" Scale="0" Size="3" SourceColumn="IDCAJA" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_IDCENTROSUMI" Precision="0" ProviderType="Int32" Scale="0" Size="10" SourceColumn="IDCENTROSUMI" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_IDCENTROSUMI" Precision="0" ProviderType="Varchar2" Scale="0" Size="10" SourceColumn="IDCENTROSUMI" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_NOREMCOMCEL" Precision="0" ProviderType="Int32" Scale="0" Size="15" SourceColumn="NOREMCOMCEL" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_NOREMCOMCEL" Precision="0" ProviderType="Varchar2" Scale="0" Size="15" SourceColumn="NOREMCOMCEL" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO "MOV_MOVIMIENTO" ("IDDOCUMENTO", "NUMERO", "ANULADO", "FECHADOCUMENTO", "FECHAVENCIMIENTO", "IDBODEGADESTINO", "IDBODEGAORIGEN", "IDCANAL", "IDCCOSTO", "IDDOCREFERENCIA", "IDLISTA", "IDSEDE", "IDTERCERO", "IDVENDEDOR", "IMPRESO", "NOTA", "NUMEROREFERENCIA", "SALDO", "VALORBASE", "VALORIVA", "VALORPAGOS", "VALORRETENCION", "SUCURSAL", "IDFORMAPAGO", "NOFACCOMCEL", "IDCAJA", "IDCENTROSUMI", "NOREMCOMCEL") VALUES (:IDDOCUMENTO, :NUMERO, :ANULADO, :FECHADOCUMENTO, :FECHAVENCIMIENTO, :IDBODEGADESTINO, :IDBODEGAORIGEN, :IDCANAL, :IDCCOSTO, :IDDOCREFERENCIA, :IDLISTA, :IDSEDE, :IDTERCERO, :IDVENDEDOR, :IMPRESO, :NOTA, :NUMEROREFERENCIA, :SALDO, :VALORBASE, :VALORIVA, :VALORPAGOS, :VALORRETENCION, :SUCURSAL, :IDFORMAPAGO, :NOFACCOMCEL, :IDCAJA, :IDCENTROSUMI, :NOREMCOMCEL)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="IDDOCUMENTO" Precision="0" ProviderType="Varchar2" Scale="0" Size="5" SourceColumn="IDDOCUMENTO" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="NUMERO" Precision="0" ProviderType="Decimal" Scale="0" Size="22" SourceColumn="NUMERO" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="ANULADO" Precision="0" ProviderType="Char" Scale="0" Size="1" SourceColumn="ANULADO" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Date" Direction="Input" ParameterName="FECHADOCUMENTO" Precision="0" ProviderType="Date" Scale="0" Size="7" SourceColumn="FECHADOCUMENTO" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Date" Direction="Input" ParameterName="FECHAVENCIMIENTO" Precision="0" ProviderType="Date" Scale="0" Size="7" SourceColumn="FECHAVENCIMIENTO" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="IDBODEGADESTINO" Precision="0" ProviderType="Varchar2" Scale="0" Size="5" SourceColumn="IDBODEGADESTINO" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="IDBODEGAORIGEN" Precision="0" ProviderType="Varchar2" Scale="0" Size="5" SourceColumn="IDBODEGAORIGEN" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="IDCANAL" Precision="0" ProviderType="Varchar2" Scale="0" Size="5" SourceColumn="IDCANAL" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="IDCCOSTO" Precision="0" ProviderType="Varchar2" Scale="0" Size="5" SourceColumn="IDCCOSTO" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="IDDOCREFERENCIA" Precision="0" ProviderType="Varchar2" Scale="0" Size="5" SourceColumn="IDDOCREFERENCIA" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="IDLISTA" Precision="0" ProviderType="Varchar2" Scale="0" Size="5" SourceColumn="IDLISTA" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="IDSEDE" Precision="0" ProviderType="Varchar2" Scale="0" Size="5" SourceColumn="IDSEDE" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="IDTERCERO" Precision="0" ProviderType="Varchar2" Scale="0" Size="15" SourceColumn="IDTERCERO" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="IDVENDEDOR" Precision="0" ProviderType="Varchar2" Scale="0" Size="15" SourceColumn="IDVENDEDOR" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="IMPRESO" Precision="0" ProviderType="Char" Scale="0" Size="1" SourceColumn="IMPRESO" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="NOTA" Precision="0" ProviderType="Varchar2" Scale="0" Size="150" SourceColumn="NOTA" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="NUMEROREFERENCIA" Precision="0" ProviderType="Decimal" Scale="0" Size="22" SourceColumn="NUMEROREFERENCIA" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="SALDO" Precision="0" ProviderType="Decimal" Scale="0" Size="22" SourceColumn="SALDO" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="VALORBASE" Precision="0" ProviderType="Decimal" Scale="0" Size="22" SourceColumn="VALORBASE" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="VALORIVA" Precision="0" ProviderType="Decimal" Scale="0" Size="22" SourceColumn="VALORIVA" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="VALORPAGOS" Precision="0" ProviderType="Decimal" Scale="0" Size="22" SourceColumn="VALORPAGOS" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="VALORRETENCION" Precision="0" ProviderType="Decimal" Scale="0" Size="22" SourceColumn="VALORRETENCION" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="SUCURSAL" Precision="0" ProviderType="Decimal" Scale="0" Size="22" SourceColumn="SUCURSAL" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="IDFORMAPAGO" Precision="0" ProviderType="Varchar2" Scale="0" Size="5" SourceColumn="IDFORMAPAGO" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="NOFACCOMCEL" Precision="0" ProviderType="Varchar2" Scale="0" Size="15" SourceColumn="NOFACCOMCEL" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="IDCAJA" Precision="0" ProviderType="Varchar2" Scale="0" Size="3" SourceColumn="IDCAJA" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="IDCENTROSUMI" Precision="0" ProviderType="Varchar2" Scale="0" Size="10" SourceColumn="IDCENTROSUMI" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="NOREMCOMCEL" Precision="0" ProviderType="Varchar2" Scale="0" Size="15" SourceColumn="NOREMCOMCEL" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT     IDDOCUMENTO, NUMERO, ANULADO, FECHADOCUMENTO, FECHAVENCIMIENTO, IDBODEGADESTINO, IDBODEGAORIGEN, IDCANAL, IDCCOSTO, 
                      IDDOCREFERENCIA, IDLISTA, IDSEDE, IDTERCERO, IDVENDEDOR, IMPRESO, NOTA, NUMEROREFERENCIA, SALDO, VALORBASE, VALORIVA, VALORPAGOS, 
                      VALORRETENCION, SUCURSAL, IDFORMAPAGO, NOFACCOMCEL, IDCAJA, IDCENTROSUMI, NOREMCOMCEL
FROM         MOV_MOVIMIENTO</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE "MOV_MOVIMIENTO" SET "IDDOCUMENTO" = :IDDOCUMENTO, "NUMERO" = :NUMERO, "ANULADO" = :ANULADO, "FECHADOCUMENTO" = :FECHADOCUMENTO, "FECHAVENCIMIENTO" = :FECHAVENCIMIENTO, "IDBODEGADESTINO" = :IDBODEGADESTINO, "IDBODEGAORIGEN" = :IDBODEGAORIGEN, "IDCANAL" = :IDCANAL, "IDCCOSTO" = :IDCCOSTO, "IDDOCREFERENCIA" = :IDDOCREFERENCIA, "IDLISTA" = :IDLISTA, "IDSEDE" = :IDSEDE, "IDTERCERO" = :IDTERCERO, "IDVENDEDOR" = :IDVENDEDOR, "IMPRESO" = :IMPRESO, "NOTA" = :NOTA, "NUMEROREFERENCIA" = :NUMEROREFERENCIA, "SALDO" = :SALDO, "VALORBASE" = :VALORBASE, "VALORIVA" = :VALORIVA, "VALORPAGOS" = :VALORPAGOS, "VALORRETENCION" = :VALORRETENCION, "SUCURSAL" = :SUCURSAL, "IDFORMAPAGO" = :IDFORMAPAGO, "NOFACCOMCEL" = :NOFACCOMCEL, "IDCAJA" = :IDCAJA, "IDCENTROSUMI" = :IDCENTROSUMI, "NOREMCOMCEL" = :NOREMCOMCEL WHERE (("IDDOCUMENTO" = :Original_IDDOCUMENTO) AND ("NUMERO" = :Original_NUMERO) AND ((:IsNull_ANULADO = 1 AND "ANULADO" IS NULL) OR ("ANULADO" = :Original_ANULADO)) AND ((:IsNull_FECHADOCUMENTO = 1 AND "FECHADOCUMENTO" IS NULL) OR ("FECHADOCUMENTO" = :Original_FECHADOCUMENTO)) AND ((:IsNull_FECHAVENCIMIENTO = 1 AND "FECHAVENCIMIENTO" IS NULL) OR ("FECHAVENCIMIENTO" = :Original_FECHAVENCIMIENTO)) AND ((:IsNull_IDBODEGADESTINO = 1 AND "IDBODEGADESTINO" IS NULL) OR ("IDBODEGADESTINO" = :Original_IDBODEGADESTINO)) AND ((:IsNull_IDBODEGAORIGEN = 1 AND "IDBODEGAORIGEN" IS NULL) OR ("IDBODEGAORIGEN" = :Original_IDBODEGAORIGEN)) AND ((:IsNull_IDCANAL = 1 AND "IDCANAL" IS NULL) OR ("IDCANAL" = :Original_IDCANAL)) AND ((:IsNull_IDCCOSTO = 1 AND "IDCCOSTO" IS NULL) OR ("IDCCOSTO" = :Original_IDCCOSTO)) AND ((:IsNull_IDDOCREFERENCIA = 1 AND "IDDOCREFERENCIA" IS NULL) OR ("IDDOCREFERENCIA" = :Original_IDDOCREFERENCIA)) AND ((:IsNull_IDLISTA = 1 AND "IDLISTA" IS NULL) OR ("IDLISTA" = :Original_IDLISTA)) AND ((:IsNull_IDSEDE = 1 AND "IDSEDE" IS NULL) OR ("IDSEDE" = :Original_IDSEDE)) AND ((:IsNull_IDTERCERO = 1 AND "IDTERCERO" IS NULL) OR ("IDTERCERO" = :Original_IDTERCERO)) AND ((:IsNull_IDVENDEDOR = 1 AND "IDVENDEDOR" IS NULL) OR ("IDVENDEDOR" = :Original_IDVENDEDOR)) AND ((:IsNull_IMPRESO = 1 AND "IMPRESO" IS NULL) OR ("IMPRESO" = :Original_IMPRESO)) AND ((:IsNull_NOTA = 1 AND "NOTA" IS NULL) OR ("NOTA" = :Original_NOTA)) AND ((:IsNull_NUMEROREFERENCIA = 1 AND "NUMEROREFERENCIA" IS NULL) OR ("NUMEROREFERENCIA" = :Original_NUMEROREFERENCIA)) AND ((:IsNull_SALDO = 1 AND "SALDO" IS NULL) OR ("SALDO" = :Original_SALDO)) AND ((:IsNull_VALORBASE = 1 AND "VALORBASE" IS NULL) OR ("VALORBASE" = :Original_VALORBASE)) AND ((:IsNull_VALORIVA = 1 AND "VALORIVA" IS NULL) OR ("VALORIVA" = :Original_VALORIVA)) AND ((:IsNull_VALORPAGOS = 1 AND "VALORPAGOS" IS NULL) OR ("VALORPAGOS" = :Original_VALORPAGOS)) AND ((:IsNull_VALORRETENCION = 1 AND "VALORRETENCION" IS NULL) OR ("VALORRETENCION" = :Original_VALORRETENCION)) AND ((:IsNull_SUCURSAL = 1 AND "SUCURSAL" IS NULL) OR ("SUCURSAL" = :Original_SUCURSAL)) AND ((:IsNull_IDFORMAPAGO = 1 AND "IDFORMAPAGO" IS NULL) OR ("IDFORMAPAGO" = :Original_IDFORMAPAGO)) AND ((:IsNull_NOFACCOMCEL = 1 AND "NOFACCOMCEL" IS NULL) OR ("NOFACCOMCEL" = :Original_NOFACCOMCEL)) AND ((:IsNull_IDCAJA = 1 AND "IDCAJA" IS NULL) OR ("IDCAJA" = :Original_IDCAJA)) AND ((:IsNull_IDCENTROSUMI = 1 AND "IDCENTROSUMI" IS NULL) OR ("IDCENTROSUMI" = :Original_IDCENTROSUMI)) AND ((:IsNull_NOREMCOMCEL = 1 AND "NOREMCOMCEL" IS NULL) OR ("NOREMCOMCEL" = :Original_NOREMCOMCEL)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="IDDOCUMENTO" Precision="0" ProviderType="Varchar2" Scale="0" Size="5" SourceColumn="IDDOCUMENTO" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="NUMERO" Precision="0" ProviderType="Decimal" Scale="0" Size="22" SourceColumn="NUMERO" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="ANULADO" Precision="0" ProviderType="Char" Scale="0" Size="1" SourceColumn="ANULADO" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Date" Direction="Input" ParameterName="FECHADOCUMENTO" Precision="0" ProviderType="Date" Scale="0" Size="7" SourceColumn="FECHADOCUMENTO" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Date" Direction="Input" ParameterName="FECHAVENCIMIENTO" Precision="0" ProviderType="Date" Scale="0" Size="7" SourceColumn="FECHAVENCIMIENTO" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="IDBODEGADESTINO" Precision="0" ProviderType="Varchar2" Scale="0" Size="5" SourceColumn="IDBODEGADESTINO" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="IDBODEGAORIGEN" Precision="0" ProviderType="Varchar2" Scale="0" Size="5" SourceColumn="IDBODEGAORIGEN" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="IDCANAL" Precision="0" ProviderType="Varchar2" Scale="0" Size="5" SourceColumn="IDCANAL" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="IDCCOSTO" Precision="0" ProviderType="Varchar2" Scale="0" Size="5" SourceColumn="IDCCOSTO" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="IDDOCREFERENCIA" Precision="0" ProviderType="Varchar2" Scale="0" Size="5" SourceColumn="IDDOCREFERENCIA" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="IDLISTA" Precision="0" ProviderType="Varchar2" Scale="0" Size="5" SourceColumn="IDLISTA" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="IDSEDE" Precision="0" ProviderType="Varchar2" Scale="0" Size="5" SourceColumn="IDSEDE" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="IDTERCERO" Precision="0" ProviderType="Varchar2" Scale="0" Size="15" SourceColumn="IDTERCERO" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="IDVENDEDOR" Precision="0" ProviderType="Varchar2" Scale="0" Size="15" SourceColumn="IDVENDEDOR" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="IMPRESO" Precision="0" ProviderType="Char" Scale="0" Size="1" SourceColumn="IMPRESO" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="NOTA" Precision="0" ProviderType="Varchar2" Scale="0" Size="150" SourceColumn="NOTA" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="NUMEROREFERENCIA" Precision="0" ProviderType="Decimal" Scale="0" Size="22" SourceColumn="NUMEROREFERENCIA" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="SALDO" Precision="0" ProviderType="Decimal" Scale="0" Size="22" SourceColumn="SALDO" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="VALORBASE" Precision="0" ProviderType="Decimal" Scale="0" Size="22" SourceColumn="VALORBASE" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="VALORIVA" Precision="0" ProviderType="Decimal" Scale="0" Size="22" SourceColumn="VALORIVA" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="VALORPAGOS" Precision="0" ProviderType="Decimal" Scale="0" Size="22" SourceColumn="VALORPAGOS" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="VALORRETENCION" Precision="0" ProviderType="Decimal" Scale="0" Size="22" SourceColumn="VALORRETENCION" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="SUCURSAL" Precision="0" ProviderType="Decimal" Scale="0" Size="22" SourceColumn="SUCURSAL" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="IDFORMAPAGO" Precision="0" ProviderType="Varchar2" Scale="0" Size="5" SourceColumn="IDFORMAPAGO" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="NOFACCOMCEL" Precision="0" ProviderType="Varchar2" Scale="0" Size="15" SourceColumn="NOFACCOMCEL" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="IDCAJA" Precision="0" ProviderType="Varchar2" Scale="0" Size="3" SourceColumn="IDCAJA" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="IDCENTROSUMI" Precision="0" ProviderType="Varchar2" Scale="0" Size="10" SourceColumn="IDCENTROSUMI" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="NOREMCOMCEL" Precision="0" ProviderType="Varchar2" Scale="0" Size="15" SourceColumn="NOREMCOMCEL" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_IDDOCUMENTO" Precision="0" ProviderType="Varchar2" Scale="0" Size="5" SourceColumn="IDDOCUMENTO" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="Original_NUMERO" Precision="0" ProviderType="Decimal" Scale="0" Size="22" SourceColumn="NUMERO" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_ANULADO" Precision="0" ProviderType="Int32" Scale="0" Size="1" SourceColumn="ANULADO" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="Original_ANULADO" Precision="0" ProviderType="Char" Scale="0" Size="1" SourceColumn="ANULADO" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_FECHADOCUMENTO" Precision="0" ProviderType="Int32" Scale="0" Size="7" SourceColumn="FECHADOCUMENTO" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Date" Direction="Input" ParameterName="Original_FECHADOCUMENTO" Precision="0" ProviderType="Date" Scale="0" Size="7" SourceColumn="FECHADOCUMENTO" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_FECHAVENCIMIENTO" Precision="0" ProviderType="Int32" Scale="0" Size="7" SourceColumn="FECHAVENCIMIENTO" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Date" Direction="Input" ParameterName="Original_FECHAVENCIMIENTO" Precision="0" ProviderType="Date" Scale="0" Size="7" SourceColumn="FECHAVENCIMIENTO" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_IDBODEGADESTINO" Precision="0" ProviderType="Int32" Scale="0" Size="5" SourceColumn="IDBODEGADESTINO" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_IDBODEGADESTINO" Precision="0" ProviderType="Varchar2" Scale="0" Size="5" SourceColumn="IDBODEGADESTINO" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_IDBODEGAORIGEN" Precision="0" ProviderType="Int32" Scale="0" Size="5" SourceColumn="IDBODEGAORIGEN" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_IDBODEGAORIGEN" Precision="0" ProviderType="Varchar2" Scale="0" Size="5" SourceColumn="IDBODEGAORIGEN" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_IDCANAL" Precision="0" ProviderType="Int32" Scale="0" Size="5" SourceColumn="IDCANAL" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_IDCANAL" Precision="0" ProviderType="Varchar2" Scale="0" Size="5" SourceColumn="IDCANAL" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_IDCCOSTO" Precision="0" ProviderType="Int32" Scale="0" Size="5" SourceColumn="IDCCOSTO" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_IDCCOSTO" Precision="0" ProviderType="Varchar2" Scale="0" Size="5" SourceColumn="IDCCOSTO" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_IDDOCREFERENCIA" Precision="0" ProviderType="Int32" Scale="0" Size="5" SourceColumn="IDDOCREFERENCIA" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_IDDOCREFERENCIA" Precision="0" ProviderType="Varchar2" Scale="0" Size="5" SourceColumn="IDDOCREFERENCIA" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_IDLISTA" Precision="0" ProviderType="Int32" Scale="0" Size="5" SourceColumn="IDLISTA" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_IDLISTA" Precision="0" ProviderType="Varchar2" Scale="0" Size="5" SourceColumn="IDLISTA" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_IDSEDE" Precision="0" ProviderType="Int32" Scale="0" Size="5" SourceColumn="IDSEDE" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_IDSEDE" Precision="0" ProviderType="Varchar2" Scale="0" Size="5" SourceColumn="IDSEDE" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_IDTERCERO" Precision="0" ProviderType="Int32" Scale="0" Size="15" SourceColumn="IDTERCERO" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_IDTERCERO" Precision="0" ProviderType="Varchar2" Scale="0" Size="15" SourceColumn="IDTERCERO" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_IDVENDEDOR" Precision="0" ProviderType="Int32" Scale="0" Size="15" SourceColumn="IDVENDEDOR" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_IDVENDEDOR" Precision="0" ProviderType="Varchar2" Scale="0" Size="15" SourceColumn="IDVENDEDOR" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_IMPRESO" Precision="0" ProviderType="Int32" Scale="0" Size="1" SourceColumn="IMPRESO" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="Original_IMPRESO" Precision="0" ProviderType="Char" Scale="0" Size="1" SourceColumn="IMPRESO" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_NOTA" Precision="0" ProviderType="Int32" Scale="0" Size="150" SourceColumn="NOTA" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_NOTA" Precision="0" ProviderType="Varchar2" Scale="0" Size="150" SourceColumn="NOTA" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_NUMEROREFERENCIA" Precision="0" ProviderType="Int32" Scale="0" Size="22" SourceColumn="NUMEROREFERENCIA" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="Original_NUMEROREFERENCIA" Precision="0" ProviderType="Decimal" Scale="0" Size="22" SourceColumn="NUMEROREFERENCIA" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_SALDO" Precision="0" ProviderType="Int32" Scale="0" Size="22" SourceColumn="SALDO" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="Original_SALDO" Precision="0" ProviderType="Decimal" Scale="0" Size="22" SourceColumn="SALDO" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_VALORBASE" Precision="0" ProviderType="Int32" Scale="0" Size="22" SourceColumn="VALORBASE" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="Original_VALORBASE" Precision="0" ProviderType="Decimal" Scale="0" Size="22" SourceColumn="VALORBASE" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_VALORIVA" Precision="0" ProviderType="Int32" Scale="0" Size="22" SourceColumn="VALORIVA" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="Original_VALORIVA" Precision="0" ProviderType="Decimal" Scale="0" Size="22" SourceColumn="VALORIVA" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_VALORPAGOS" Precision="0" ProviderType="Int32" Scale="0" Size="22" SourceColumn="VALORPAGOS" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="Original_VALORPAGOS" Precision="0" ProviderType="Decimal" Scale="0" Size="22" SourceColumn="VALORPAGOS" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_VALORRETENCION" Precision="0" ProviderType="Int32" Scale="0" Size="22" SourceColumn="VALORRETENCION" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="Original_VALORRETENCION" Precision="0" ProviderType="Decimal" Scale="0" Size="22" SourceColumn="VALORRETENCION" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_SUCURSAL" Precision="0" ProviderType="Int32" Scale="0" Size="22" SourceColumn="SUCURSAL" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="Original_SUCURSAL" Precision="0" ProviderType="Decimal" Scale="0" Size="22" SourceColumn="SUCURSAL" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_IDFORMAPAGO" Precision="0" ProviderType="Int32" Scale="0" Size="5" SourceColumn="IDFORMAPAGO" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_IDFORMAPAGO" Precision="0" ProviderType="Varchar2" Scale="0" Size="5" SourceColumn="IDFORMAPAGO" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_NOFACCOMCEL" Precision="0" ProviderType="Int32" Scale="0" Size="15" SourceColumn="NOFACCOMCEL" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_NOFACCOMCEL" Precision="0" ProviderType="Varchar2" Scale="0" Size="15" SourceColumn="NOFACCOMCEL" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_IDCAJA" Precision="0" ProviderType="Int32" Scale="0" Size="3" SourceColumn="IDCAJA" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_IDCAJA" Precision="0" ProviderType="Varchar2" Scale="0" Size="3" SourceColumn="IDCAJA" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_IDCENTROSUMI" Precision="0" ProviderType="Int32" Scale="0" Size="10" SourceColumn="IDCENTROSUMI" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_IDCENTROSUMI" Precision="0" ProviderType="Varchar2" Scale="0" Size="10" SourceColumn="IDCENTROSUMI" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_NOREMCOMCEL" Precision="0" ProviderType="Int32" Scale="0" Size="15" SourceColumn="NOREMCOMCEL" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_NOREMCOMCEL" Precision="0" ProviderType="Varchar2" Scale="0" Size="15" SourceColumn="NOREMCOMCEL" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="IDDOCUMENTO" DataSetColumn="IDDOCUMENTO" />
              <Mapping SourceColumn="NUMERO" DataSetColumn="NUMERO" />
              <Mapping SourceColumn="ANULADO" DataSetColumn="ANULADO" />
              <Mapping SourceColumn="FECHADOCUMENTO" DataSetColumn="FECHADOCUMENTO" />
              <Mapping SourceColumn="FECHAVENCIMIENTO" DataSetColumn="FECHAVENCIMIENTO" />
              <Mapping SourceColumn="IDBODEGADESTINO" DataSetColumn="IDBODEGADESTINO" />
              <Mapping SourceColumn="IDBODEGAORIGEN" DataSetColumn="IDBODEGAORIGEN" />
              <Mapping SourceColumn="IDCANAL" DataSetColumn="IDCANAL" />
              <Mapping SourceColumn="IDCCOSTO" DataSetColumn="IDCCOSTO" />
              <Mapping SourceColumn="IDDOCREFERENCIA" DataSetColumn="IDDOCREFERENCIA" />
              <Mapping SourceColumn="IDLISTA" DataSetColumn="IDLISTA" />
              <Mapping SourceColumn="IDSEDE" DataSetColumn="IDSEDE" />
              <Mapping SourceColumn="IDTERCERO" DataSetColumn="IDTERCERO" />
              <Mapping SourceColumn="IDVENDEDOR" DataSetColumn="IDVENDEDOR" />
              <Mapping SourceColumn="IMPRESO" DataSetColumn="IMPRESO" />
              <Mapping SourceColumn="NOTA" DataSetColumn="NOTA" />
              <Mapping SourceColumn="NUMEROREFERENCIA" DataSetColumn="NUMEROREFERENCIA" />
              <Mapping SourceColumn="SALDO" DataSetColumn="SALDO" />
              <Mapping SourceColumn="VALORBASE" DataSetColumn="VALORBASE" />
              <Mapping SourceColumn="VALORIVA" DataSetColumn="VALORIVA" />
              <Mapping SourceColumn="VALORPAGOS" DataSetColumn="VALORPAGOS" />
              <Mapping SourceColumn="VALORRETENCION" DataSetColumn="VALORRETENCION" />
              <Mapping SourceColumn="SUCURSAL" DataSetColumn="SUCURSAL" />
              <Mapping SourceColumn="IDFORMAPAGO" DataSetColumn="IDFORMAPAGO" />
              <Mapping SourceColumn="NOFACCOMCEL" DataSetColumn="NOFACCOMCEL" />
              <Mapping SourceColumn="IDCAJA" DataSetColumn="IDCAJA" />
              <Mapping SourceColumn="IDCENTROSUMI" DataSetColumn="IDCENTROSUMI" />
              <Mapping SourceColumn="NOREMCOMCEL" DataSetColumn="NOREMCOMCEL" />
            </Mappings>
            <Sources>
              <DbSource ConnectionRef="ConnectionString (MySettings)" DbObjectType="Unknown" GenerateShortCommands="true" GeneratorSourceName="CuentaNFacComcel" Modifier="Public" Name="CuentaNFacComcel" QueryType="Scalar" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy" UserSourceName="CuentaNFacComcel">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT        COUNT(*) AS NFacComcel
FROM            MOV_MOVIMIENTO
WHERE        (NOFACCOMCEL = :PNOFACCOMCEL)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="PNOFACCOMCEL" ColumnName="NOFACCOMCEL" DataSourceName="SAMUEL.MOV_MOVIMIENTO" DataTypeServer="NVARCHAR2(15)" DbType="String" Direction="Input" ParameterName=":PNOFACCOMCEL" Precision="0" ProviderType="Varchar2" Scale="0" Size="15" SourceColumn="NOFACCOMCEL" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
              <DbSource ConnectionRef="ConnectionString (MySettings)" DbObjectName="SAMUEL.MOV_MOVIMIENTO" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="FillByFechaDocumento" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetDataByFechaDocumento" GeneratorSourceName="FillByFechaDocumento" GetMethodModifier="Public" GetMethodName="GetDataByFechaDocumento" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataByFechaDocumento" UserSourceName="FillByFechaDocumento">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT ANULADO, FECHADOCUMENTO, FECHAVENCIMIENTO, IDBODEGADESTINO, IDBODEGAORIGEN, IDCAJA, IDCANAL, IDCCOSTO, IDCENTROSUMI, IDDOCREFERENCIA, IDDOCUMENTO, IDFORMAPAGO, IDLISTA, IDSEDE, IDTERCERO, IDVENDEDOR, IMPRESO, NOFACCOMCEL, NOREMCOMCEL, NOTA, NUMERO, NUMEROREFERENCIA, SALDO, SUCURSAL, VALORBASE, VALORIVA, VALORPAGOS, VALORRETENCION FROM MOV_MOVIMIENTO WHERE (FECHADOCUMENTO BETWEEN :PDESDEF AND :PHASTAF) ORDER BY FECHADOCUMENTO</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="PDESDEF" ColumnName="FECHADOCUMENTO" DataSourceName="" DataTypeServer="DATE(7)" DbType="DateTime" Direction="Input" ParameterName=":PDESDEF" Precision="0" ProviderType="Date" Scale="0" Size="7" SourceColumn="FECHADOCUMENTO" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="PHASTAF" ColumnName="FECHADOCUMENTO" DataSourceName="" DataTypeServer="DATE(7)" DbType="DateTime" Direction="Input" ParameterName=":PHASTAF" Precision="0" ProviderType="Date" Scale="0" Size="7" SourceColumn="FECHADOCUMENTO" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
              <DbSource ConnectionRef="ConnectionString (MySettings)" DbObjectName="SAMUEL.MOV_MOVIMIENTO" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="FillByIdDocumentoNumero" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetDataByIdDocumentoNumero" GeneratorSourceName="FillByIdDocumentoNumero" GetMethodModifier="Public" GetMethodName="GetDataByIdDocumentoNumero" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataByIdDocumentoNumero" UserSourceName="FillByIdDocumentoNumero">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT ANULADO, FECHADOCUMENTO, FECHAVENCIMIENTO, IDBODEGADESTINO, IDBODEGAORIGEN, IDCAJA, IDCANAL, IDCCOSTO, IDCENTROSUMI, IDDOCREFERENCIA, IDDOCUMENTO, IDFORMAPAGO, IDLISTA, IDSEDE, IDTERCERO, IDVENDEDOR, IMPRESO, NOFACCOMCEL, NOREMCOMCEL, NOTA, NUMERO, NUMEROREFERENCIA, SALDO, SUCURSAL, VALORBASE, VALORIVA, VALORPAGOS, VALORRETENCION FROM MOV_MOVIMIENTO WHERE (IDDOCUMENTO = :PIDDOCUMENTO) AND (NUMERO = :PNUMERO)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="PIDDOCUMENTO" ColumnName="IDDOCUMENTO" DataSourceName="" DataTypeServer="VARCHAR2(5)" DbType="String" Direction="Input" ParameterName=":PIDDOCUMENTO" Precision="0" ProviderType="Varchar2" Scale="0" Size="5" SourceColumn="IDDOCUMENTO" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="PNUMERO" ColumnName="NUMERO" DataSourceName="" DataTypeServer="NUMBER(22)" DbType="Decimal" Direction="Input" ParameterName=":PNUMERO" Precision="38" ProviderType="Decimal" Scale="0" Size="22" SourceColumn="NUMERO" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
              <DbSource ConnectionRef="ConnectionString (MySettings)" DbObjectName="SAMUEL.CAR_FORMASPAGO" DbObjectType="Table" GenerateShortCommands="true" GeneratorSourceName="GetDescuentoFormaPago" Modifier="Public" Name="GetDescuentoFormaPago" QueryType="Scalar" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy1" UserSourceName="GetDescuentoFormaPago">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT     CAR_FORMASPAGO.DESCUENTO
FROM         MOV_MOVIMIENTO, CAR_FORMASPAGO
WHERE     MOV_MOVIMIENTO.IDFORMAPAGO = CAR_FORMASPAGO.IDFORMAPAGO AND (MOV_MOVIMIENTO.IDDOCUMENTO = :PDOCUMENTO) AND 
                      (MOV_MOVIMIENTO.NUMERO = :PNUMERO)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="PDOCUMENTO" ColumnName="IDDOCUMENTO" DataSourceName="" DataTypeServer="VARCHAR2(5)" DbType="String" Direction="Input" ParameterName=":PDOCUMENTO" Precision="0" ProviderType="Varchar2" Scale="0" Size="5" SourceColumn="IDDOCUMENTO" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="PNUMERO" ColumnName="NUMERO" DataSourceName="" DataTypeServer="NUMBER(22)" DbType="Decimal" Direction="Input" ParameterName=":PNUMERO" Precision="38" ProviderType="Decimal" Scale="0" Size="22" SourceColumn="NUMERO" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
              <DbSource ConnectionRef="ConnectionString (MySettings)" DbObjectName="SAMUEL.CAR_FORMASPAGO" DbObjectType="Table" GenerateShortCommands="true" GeneratorSourceName="GetDiasFormaPago" Modifier="Public" Name="GetDiasFormaPago" QueryType="Scalar" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy2" UserSourceName="GetDiasFormaPago">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT CAR.NDIAS
FROM MOV_MOVIMIENTO MOV, CAR_FORMASPAGO CAR
WHERE MOV.IDFORMAPAGO=CAR.IDFORMAPAGO
	AND MOV.IDDOCUMENTO=:PIDDOCUMENTO
	AND MOV.NUMERO=:PNUMERO</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="PIDDOCUMENTO" ColumnName="IDDOCUMENTO" DataSourceName="" DataTypeServer="VARCHAR2(5)" DbType="String" Direction="Input" ParameterName=":PIDDOCUMENTO" Precision="0" ProviderType="Varchar2" Scale="0" Size="5" SourceColumn="IDDOCUMENTO" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="PNUMERO" ColumnName="NUMERO" DataSourceName="" DataTypeServer="NUMBER(22)" DbType="Decimal" Direction="Input" ParameterName=":PNUMERO" Precision="38" ProviderType="Decimal" Scale="0" Size="22" SourceColumn="NUMERO" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
              <DbSource ConnectionRef="ConnectionString (MySettings)" DbObjectType="Unknown" GenerateShortCommands="true" GeneratorSourceName="GetValorFacturasByFechas" Modifier="Public" Name="GetValorFacturasByFechas" QueryType="Scalar" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy3" UserSourceName="GetValorFacturasByFechas">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT        SUM(MOV_MOVIMIENTO.VALORBASE + MOV_MOVIMIENTO.VALORIVA) AS VRFACTURA
FROM            MOV_MOVIMIENTO INNER JOIN
                         GLO_TIPODOCUMENTO ON MOV_MOVIMIENTO.IDDOCUMENTO = GLO_TIPODOCUMENTO.TIPODOC INNER JOIN
                         CAR_FORMASPAGO ON MOV_MOVIMIENTO.IDFORMAPAGO = CAR_FORMASPAGO.IDFORMAPAGO
WHERE        (MOV_MOVIMIENTO.FECHADOCUMENTO BETWEEN :PDESDEF AND :PHASTAF) AND (MOV_MOVIMIENTO.IDCAJA = :PIDCAJA) AND 
                         (GLO_TIPODOCUMENTO.DOCES = 4) AND (CAR_FORMASPAGO.NDIAS = 0)</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </Sources>
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="MOV_MOVIMIENTODETALLETableAdapter" GeneratorDataComponentClassName="MOV_MOVIMIENTODETALLETableAdapter" Name="MOV_MOVIMIENTODETALLE" UserDataComponentName="MOV_MOVIMIENTODETALLETableAdapter">
            <MainSource>
              <DbSource ConnectionRef="ConnectionString (MySettings)" DbObjectName="SAMUEL.MOV_MOVIMIENTODETALLE" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM "MOV_MOVIMIENTODETALLE" WHERE (("IDDOCUMENTO" = :Original_IDDOCUMENTO) AND ("NUMERO" = :Original_NUMERO) AND ("NUMEROLINEA" = :Original_NUMEROLINEA) AND ("IDPRODUCTO" = :Original_IDPRODUCTO) AND ((:IsNull_IDIVA = 1 AND "IDIVA" IS NULL) OR ("IDIVA" = :Original_IDIVA)) AND ((:IsNull_CANTIDAD = 1 AND "CANTIDAD" IS NULL) OR ("CANTIDAD" = :Original_CANTIDAD)) AND ((:IsNull_DESCUENTO1 = 1 AND "DESCUENTO1" IS NULL) OR ("DESCUENTO1" = :Original_DESCUENTO1)) AND ((:IsNull_DESCUENTO2 = 1 AND "DESCUENTO2" IS NULL) OR ("DESCUENTO2" = :Original_DESCUENTO2)) AND ((:IsNull_VALORBASE = 1 AND "VALORBASE" IS NULL) OR ("VALORBASE" = :Original_VALORBASE)) AND ((:IsNull_VALORIVA = 1 AND "VALORIVA" IS NULL) OR ("VALORIVA" = :Original_VALORIVA)) AND ((:IsNull_IDTIPOLISTA = 1 AND "IDTIPOLISTA" IS NULL) OR ("IDTIPOLISTA" = :Original_IDTIPOLISTA)) AND ((:IsNull_IDPREPACK = 1 AND "IDPREPACK" IS NULL) OR ("IDPREPACK" = :Original_IDPREPACK)) AND ((:IsNull_IDPRODDESTINO = 1 AND "IDPRODDESTINO" IS NULL) OR ("IDPRODDESTINO" = :Original_IDPRODDESTINO)) AND ((:IsNull_NUMEROLINEAPADRE = 1 AND "NUMEROLINEAPADRE" IS NULL) OR ("NUMEROLINEAPADRE" = :Original_NUMEROLINEAPADRE)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_IDDOCUMENTO" Precision="0" ProviderType="Varchar2" Scale="0" Size="5" SourceColumn="IDDOCUMENTO" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="Original_NUMERO" Precision="0" ProviderType="Decimal" Scale="0" Size="22" SourceColumn="NUMERO" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="Original_NUMEROLINEA" Precision="0" ProviderType="Decimal" Scale="0" Size="22" SourceColumn="NUMEROLINEA" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_IDPRODUCTO" Precision="0" ProviderType="Varchar2" Scale="0" Size="15" SourceColumn="IDPRODUCTO" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_IDIVA" Precision="0" ProviderType="Int32" Scale="0" Size="5" SourceColumn="IDIVA" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_IDIVA" Precision="0" ProviderType="Varchar2" Scale="0" Size="5" SourceColumn="IDIVA" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_CANTIDAD" Precision="0" ProviderType="Int32" Scale="0" Size="22" SourceColumn="CANTIDAD" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="Original_CANTIDAD" Precision="0" ProviderType="Decimal" Scale="0" Size="22" SourceColumn="CANTIDAD" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_DESCUENTO1" Precision="0" ProviderType="Int32" Scale="0" Size="22" SourceColumn="DESCUENTO1" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="Original_DESCUENTO1" Precision="0" ProviderType="Decimal" Scale="0" Size="22" SourceColumn="DESCUENTO1" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_DESCUENTO2" Precision="0" ProviderType="Int32" Scale="0" Size="22" SourceColumn="DESCUENTO2" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="Original_DESCUENTO2" Precision="0" ProviderType="Decimal" Scale="0" Size="22" SourceColumn="DESCUENTO2" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_VALORBASE" Precision="0" ProviderType="Int32" Scale="0" Size="22" SourceColumn="VALORBASE" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="Original_VALORBASE" Precision="0" ProviderType="Decimal" Scale="0" Size="22" SourceColumn="VALORBASE" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_VALORIVA" Precision="0" ProviderType="Int32" Scale="0" Size="22" SourceColumn="VALORIVA" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="Original_VALORIVA" Precision="0" ProviderType="Decimal" Scale="0" Size="22" SourceColumn="VALORIVA" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_IDTIPOLISTA" Precision="0" ProviderType="Int32" Scale="0" Size="22" SourceColumn="IDTIPOLISTA" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="Original_IDTIPOLISTA" Precision="0" ProviderType="Decimal" Scale="0" Size="22" SourceColumn="IDTIPOLISTA" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_IDPREPACK" Precision="0" ProviderType="Int32" Scale="0" Size="22" SourceColumn="IDPREPACK" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="Original_IDPREPACK" Precision="0" ProviderType="Decimal" Scale="0" Size="22" SourceColumn="IDPREPACK" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_IDPRODDESTINO" Precision="0" ProviderType="Int32" Scale="0" Size="15" SourceColumn="IDPRODDESTINO" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_IDPRODDESTINO" Precision="0" ProviderType="Varchar2" Scale="0" Size="15" SourceColumn="IDPRODDESTINO" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_NUMEROLINEAPADRE" Precision="0" ProviderType="Int32" Scale="0" Size="22" SourceColumn="NUMEROLINEAPADRE" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="Original_NUMEROLINEAPADRE" Precision="0" ProviderType="Decimal" Scale="0" Size="22" SourceColumn="NUMEROLINEAPADRE" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO "MOV_MOVIMIENTODETALLE" ("IDDOCUMENTO", "NUMERO", "NUMEROLINEA", "IDPRODUCTO", "IDIVA", "CANTIDAD", "DESCUENTO1", "DESCUENTO2", "VALORBASE", "VALORIVA", "IDTIPOLISTA", "IDPREPACK", "IDPRODDESTINO", "NUMEROLINEAPADRE") VALUES (:IDDOCUMENTO, :NUMERO, :NUMEROLINEA, :IDPRODUCTO, :IDIVA, :CANTIDAD, :DESCUENTO1, :DESCUENTO2, :VALORBASE, :VALORIVA, :IDTIPOLISTA, :IDPREPACK, :IDPRODDESTINO, :NUMEROLINEAPADRE)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="IDDOCUMENTO" Precision="0" ProviderType="Varchar2" Scale="0" Size="5" SourceColumn="IDDOCUMENTO" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="NUMERO" Precision="0" ProviderType="Decimal" Scale="0" Size="22" SourceColumn="NUMERO" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="NUMEROLINEA" Precision="0" ProviderType="Decimal" Scale="0" Size="22" SourceColumn="NUMEROLINEA" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="IDPRODUCTO" Precision="0" ProviderType="Varchar2" Scale="0" Size="15" SourceColumn="IDPRODUCTO" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="IDIVA" Precision="0" ProviderType="Varchar2" Scale="0" Size="5" SourceColumn="IDIVA" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="CANTIDAD" Precision="0" ProviderType="Decimal" Scale="0" Size="22" SourceColumn="CANTIDAD" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="DESCUENTO1" Precision="0" ProviderType="Decimal" Scale="0" Size="22" SourceColumn="DESCUENTO1" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="DESCUENTO2" Precision="0" ProviderType="Decimal" Scale="0" Size="22" SourceColumn="DESCUENTO2" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="VALORBASE" Precision="0" ProviderType="Decimal" Scale="0" Size="22" SourceColumn="VALORBASE" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="VALORIVA" Precision="0" ProviderType="Decimal" Scale="0" Size="22" SourceColumn="VALORIVA" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="IDTIPOLISTA" Precision="0" ProviderType="Decimal" Scale="0" Size="22" SourceColumn="IDTIPOLISTA" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="IDPREPACK" Precision="0" ProviderType="Decimal" Scale="0" Size="22" SourceColumn="IDPREPACK" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="IDPRODDESTINO" Precision="0" ProviderType="Varchar2" Scale="0" Size="15" SourceColumn="IDPRODDESTINO" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="NUMEROLINEAPADRE" Precision="0" ProviderType="Decimal" Scale="0" Size="22" SourceColumn="NUMEROLINEAPADRE" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT        IDDOCUMENTO, NUMERO, NUMEROLINEA, IDPRODUCTO, IDIVA, CANTIDAD, DESCUENTO1, DESCUENTO2, VALORBASE, VALORIVA, IDTIPOLISTA, IDPREPACK, 
                         IDPRODDESTINO, NUMEROLINEAPADRE
FROM            MOV_MOVIMIENTODETALLE</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE "MOV_MOVIMIENTODETALLE" SET "IDDOCUMENTO" = :IDDOCUMENTO, "NUMERO" = :NUMERO, "NUMEROLINEA" = :NUMEROLINEA, "IDPRODUCTO" = :IDPRODUCTO, "IDIVA" = :IDIVA, "CANTIDAD" = :CANTIDAD, "DESCUENTO1" = :DESCUENTO1, "DESCUENTO2" = :DESCUENTO2, "VALORBASE" = :VALORBASE, "VALORIVA" = :VALORIVA, "IDTIPOLISTA" = :IDTIPOLISTA, "IDPREPACK" = :IDPREPACK, "IDPRODDESTINO" = :IDPRODDESTINO, "NUMEROLINEAPADRE" = :NUMEROLINEAPADRE WHERE (("IDDOCUMENTO" = :Original_IDDOCUMENTO) AND ("NUMERO" = :Original_NUMERO) AND ("NUMEROLINEA" = :Original_NUMEROLINEA) AND ("IDPRODUCTO" = :Original_IDPRODUCTO) AND ((:IsNull_IDIVA = 1 AND "IDIVA" IS NULL) OR ("IDIVA" = :Original_IDIVA)) AND ((:IsNull_CANTIDAD = 1 AND "CANTIDAD" IS NULL) OR ("CANTIDAD" = :Original_CANTIDAD)) AND ((:IsNull_DESCUENTO1 = 1 AND "DESCUENTO1" IS NULL) OR ("DESCUENTO1" = :Original_DESCUENTO1)) AND ((:IsNull_DESCUENTO2 = 1 AND "DESCUENTO2" IS NULL) OR ("DESCUENTO2" = :Original_DESCUENTO2)) AND ((:IsNull_VALORBASE = 1 AND "VALORBASE" IS NULL) OR ("VALORBASE" = :Original_VALORBASE)) AND ((:IsNull_VALORIVA = 1 AND "VALORIVA" IS NULL) OR ("VALORIVA" = :Original_VALORIVA)) AND ((:IsNull_IDTIPOLISTA = 1 AND "IDTIPOLISTA" IS NULL) OR ("IDTIPOLISTA" = :Original_IDTIPOLISTA)) AND ((:IsNull_IDPREPACK = 1 AND "IDPREPACK" IS NULL) OR ("IDPREPACK" = :Original_IDPREPACK)) AND ((:IsNull_IDPRODDESTINO = 1 AND "IDPRODDESTINO" IS NULL) OR ("IDPRODDESTINO" = :Original_IDPRODDESTINO)) AND ((:IsNull_NUMEROLINEAPADRE = 1 AND "NUMEROLINEAPADRE" IS NULL) OR ("NUMEROLINEAPADRE" = :Original_NUMEROLINEAPADRE)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="IDDOCUMENTO" Precision="0" ProviderType="Varchar2" Scale="0" Size="5" SourceColumn="IDDOCUMENTO" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="NUMERO" Precision="0" ProviderType="Decimal" Scale="0" Size="22" SourceColumn="NUMERO" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="NUMEROLINEA" Precision="0" ProviderType="Decimal" Scale="0" Size="22" SourceColumn="NUMEROLINEA" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="IDPRODUCTO" Precision="0" ProviderType="Varchar2" Scale="0" Size="15" SourceColumn="IDPRODUCTO" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="IDIVA" Precision="0" ProviderType="Varchar2" Scale="0" Size="5" SourceColumn="IDIVA" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="CANTIDAD" Precision="0" ProviderType="Decimal" Scale="0" Size="22" SourceColumn="CANTIDAD" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="DESCUENTO1" Precision="0" ProviderType="Decimal" Scale="0" Size="22" SourceColumn="DESCUENTO1" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="DESCUENTO2" Precision="0" ProviderType="Decimal" Scale="0" Size="22" SourceColumn="DESCUENTO2" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="VALORBASE" Precision="0" ProviderType="Decimal" Scale="0" Size="22" SourceColumn="VALORBASE" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="VALORIVA" Precision="0" ProviderType="Decimal" Scale="0" Size="22" SourceColumn="VALORIVA" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="IDTIPOLISTA" Precision="0" ProviderType="Decimal" Scale="0" Size="22" SourceColumn="IDTIPOLISTA" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="IDPREPACK" Precision="0" ProviderType="Decimal" Scale="0" Size="22" SourceColumn="IDPREPACK" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="IDPRODDESTINO" Precision="0" ProviderType="Varchar2" Scale="0" Size="15" SourceColumn="IDPRODDESTINO" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="NUMEROLINEAPADRE" Precision="0" ProviderType="Decimal" Scale="0" Size="22" SourceColumn="NUMEROLINEAPADRE" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_IDDOCUMENTO" Precision="0" ProviderType="Varchar2" Scale="0" Size="5" SourceColumn="IDDOCUMENTO" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="Original_NUMERO" Precision="0" ProviderType="Decimal" Scale="0" Size="22" SourceColumn="NUMERO" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="Original_NUMEROLINEA" Precision="0" ProviderType="Decimal" Scale="0" Size="22" SourceColumn="NUMEROLINEA" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_IDPRODUCTO" Precision="0" ProviderType="Varchar2" Scale="0" Size="15" SourceColumn="IDPRODUCTO" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_IDIVA" Precision="0" ProviderType="Int32" Scale="0" Size="5" SourceColumn="IDIVA" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_IDIVA" Precision="0" ProviderType="Varchar2" Scale="0" Size="5" SourceColumn="IDIVA" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_CANTIDAD" Precision="0" ProviderType="Int32" Scale="0" Size="22" SourceColumn="CANTIDAD" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="Original_CANTIDAD" Precision="0" ProviderType="Decimal" Scale="0" Size="22" SourceColumn="CANTIDAD" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_DESCUENTO1" Precision="0" ProviderType="Int32" Scale="0" Size="22" SourceColumn="DESCUENTO1" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="Original_DESCUENTO1" Precision="0" ProviderType="Decimal" Scale="0" Size="22" SourceColumn="DESCUENTO1" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_DESCUENTO2" Precision="0" ProviderType="Int32" Scale="0" Size="22" SourceColumn="DESCUENTO2" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="Original_DESCUENTO2" Precision="0" ProviderType="Decimal" Scale="0" Size="22" SourceColumn="DESCUENTO2" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_VALORBASE" Precision="0" ProviderType="Int32" Scale="0" Size="22" SourceColumn="VALORBASE" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="Original_VALORBASE" Precision="0" ProviderType="Decimal" Scale="0" Size="22" SourceColumn="VALORBASE" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_VALORIVA" Precision="0" ProviderType="Int32" Scale="0" Size="22" SourceColumn="VALORIVA" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="Original_VALORIVA" Precision="0" ProviderType="Decimal" Scale="0" Size="22" SourceColumn="VALORIVA" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_IDTIPOLISTA" Precision="0" ProviderType="Int32" Scale="0" Size="22" SourceColumn="IDTIPOLISTA" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="Original_IDTIPOLISTA" Precision="0" ProviderType="Decimal" Scale="0" Size="22" SourceColumn="IDTIPOLISTA" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_IDPREPACK" Precision="0" ProviderType="Int32" Scale="0" Size="22" SourceColumn="IDPREPACK" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="Original_IDPREPACK" Precision="0" ProviderType="Decimal" Scale="0" Size="22" SourceColumn="IDPREPACK" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_IDPRODDESTINO" Precision="0" ProviderType="Int32" Scale="0" Size="15" SourceColumn="IDPRODDESTINO" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_IDPRODDESTINO" Precision="0" ProviderType="Varchar2" Scale="0" Size="15" SourceColumn="IDPRODDESTINO" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_NUMEROLINEAPADRE" Precision="0" ProviderType="Int32" Scale="0" Size="22" SourceColumn="NUMEROLINEAPADRE" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="Original_NUMEROLINEAPADRE" Precision="0" ProviderType="Decimal" Scale="0" Size="22" SourceColumn="NUMEROLINEAPADRE" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="IDDOCUMENTO" DataSetColumn="IDDOCUMENTO" />
              <Mapping SourceColumn="NUMERO" DataSetColumn="NUMERO" />
              <Mapping SourceColumn="NUMEROLINEA" DataSetColumn="NUMEROLINEA" />
              <Mapping SourceColumn="IDPRODUCTO" DataSetColumn="IDPRODUCTO" />
              <Mapping SourceColumn="IDIVA" DataSetColumn="IDIVA" />
              <Mapping SourceColumn="CANTIDAD" DataSetColumn="CANTIDAD" />
              <Mapping SourceColumn="DESCUENTO1" DataSetColumn="DESCUENTO1" />
              <Mapping SourceColumn="DESCUENTO2" DataSetColumn="DESCUENTO2" />
              <Mapping SourceColumn="VALORBASE" DataSetColumn="VALORBASE" />
              <Mapping SourceColumn="VALORIVA" DataSetColumn="VALORIVA" />
              <Mapping SourceColumn="VALORLINEA" DataSetColumn="VALORLINEA" />
              <Mapping SourceColumn="IDTIPOLISTA" DataSetColumn="IDTIPOLISTA" />
              <Mapping SourceColumn="IDPREPACK" DataSetColumn="IDPREPACK" />
              <Mapping SourceColumn="IDPRODDESTINO" DataSetColumn="IDPRODDESTINO" />
              <Mapping SourceColumn="NUMEROLINEAPADRE" DataSetColumn="NUMEROLINEAPADRE" />
            </Mappings>
            <Sources>
              <DbSource ConnectionRef="ConnectionString (MySettings)" DbObjectName="SAMUEL.MOV_MOVIMIENTODETALLE" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="FillByIdDocumentoNumero" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetDataByIdDocumentoNumero" GeneratorSourceName="FillByIdDocumentoNumero" GetMethodModifier="Public" GetMethodName="GetDataByIdDocumentoNumero" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataByIdDocumentoNumero" UserSourceName="FillByIdDocumentoNumero">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT CANTIDAD, DESCUENTO1, DESCUENTO2, IDDOCUMENTO, IDIVA, IDPREPACK, IDPRODDESTINO, IDPRODUCTO, IDTIPOLISTA, NUMERO, NUMEROLINEA, NUMEROLINEAPADRE, VALORBASE, VALORIVA FROM MOV_MOVIMIENTODETALLE WHERE (IDDOCUMENTO = :PIDDOCUMENTO) AND (NUMERO = :PNUMERO) ORDER BY IDDOCUMENTO, NUMERO, NUMEROLINEA</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="PIDDOCUMENTO" ColumnName="IDDOCUMENTO" DataSourceName="" DataTypeServer="VARCHAR2(5)" DbType="String" Direction="Input" ParameterName=":PIDDOCUMENTO" Precision="0" ProviderType="Varchar2" Scale="0" Size="5" SourceColumn="IDDOCUMENTO" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="PNUMERO" ColumnName="NUMERO" DataSourceName="" DataTypeServer="NUMBER(22)" DbType="Decimal" Direction="Input" ParameterName=":PNUMERO" Precision="38" ProviderType="Decimal" Scale="0" Size="22" SourceColumn="NUMERO" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </Sources>
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="MOV_DESCRIPCIONDETTableAdapter" GeneratorDataComponentClassName="MOV_DESCRIPCIONDETTableAdapter" Name="MOV_DESCRIPCIONDET" UserDataComponentName="MOV_DESCRIPCIONDETTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="ConnectionString (MySettings)" DbObjectName="SAMUEL.MOV_DESCRIPCIONDET" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM "MOV_DESCRIPCIONDET" WHERE (("IDDOCUMENTO" = :Original_IDDOCUMENTO) AND ("NUMERO" = :Original_NUMERO) AND ("NUMEROLINEA" = :Original_NUMEROLINEA) AND ("IDPRODUCTO" = :Original_IDPRODUCTO) AND ("TIPOSUBPROD" = :Original_TIPOSUBPROD) AND ("NUMEROREGISTRO" = :Original_NUMEROREGISTRO) AND ((:IsNull_NUMEROPRODUCTO = 1 AND "NUMEROPRODUCTO" IS NULL) OR ("NUMEROPRODUCTO" = :Original_NUMEROPRODUCTO)) AND ((:IsNull_COSTO = 1 AND "COSTO" IS NULL) OR ("COSTO" = :Original_COSTO)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_IDDOCUMENTO" Precision="0" ProviderType="Varchar2" Scale="0" Size="5" SourceColumn="IDDOCUMENTO" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="Original_NUMERO" Precision="0" ProviderType="Decimal" Scale="0" Size="22" SourceColumn="NUMERO" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="Original_NUMEROLINEA" Precision="0" ProviderType="Decimal" Scale="0" Size="22" SourceColumn="NUMEROLINEA" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_IDPRODUCTO" Precision="0" ProviderType="Varchar2" Scale="0" Size="15" SourceColumn="IDPRODUCTO" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="Original_TIPOSUBPROD" Precision="0" ProviderType="Decimal" Scale="0" Size="22" SourceColumn="TIPOSUBPROD" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_NUMEROREGISTRO" Precision="0" ProviderType="Varchar2" Scale="0" Size="20" SourceColumn="NUMEROREGISTRO" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_NUMEROPRODUCTO" Precision="0" ProviderType="Int32" Scale="0" Size="22" SourceColumn="NUMEROPRODUCTO" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="Original_NUMEROPRODUCTO" Precision="0" ProviderType="Decimal" Scale="0" Size="22" SourceColumn="NUMEROPRODUCTO" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_COSTO" Precision="0" ProviderType="Int32" Scale="0" Size="22" SourceColumn="COSTO" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="Original_COSTO" Precision="0" ProviderType="Decimal" Scale="0" Size="22" SourceColumn="COSTO" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO "MOV_DESCRIPCIONDET" ("IDDOCUMENTO", "NUMERO", "NUMEROLINEA", "IDPRODUCTO", "TIPOSUBPROD", "NUMEROREGISTRO", "NUMEROPRODUCTO", "COSTO") VALUES (:IDDOCUMENTO, :NUMERO, :NUMEROLINEA, :IDPRODUCTO, :TIPOSUBPROD, :NUMEROREGISTRO, :NUMEROPRODUCTO, :COSTO)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="IDDOCUMENTO" Precision="0" ProviderType="Varchar2" Scale="0" Size="5" SourceColumn="IDDOCUMENTO" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="NUMERO" Precision="0" ProviderType="Decimal" Scale="0" Size="22" SourceColumn="NUMERO" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="NUMEROLINEA" Precision="0" ProviderType="Decimal" Scale="0" Size="22" SourceColumn="NUMEROLINEA" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="IDPRODUCTO" Precision="0" ProviderType="Varchar2" Scale="0" Size="15" SourceColumn="IDPRODUCTO" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="TIPOSUBPROD" Precision="0" ProviderType="Decimal" Scale="0" Size="22" SourceColumn="TIPOSUBPROD" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="NUMEROREGISTRO" Precision="0" ProviderType="Varchar2" Scale="0" Size="20" SourceColumn="NUMEROREGISTRO" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="NUMEROPRODUCTO" Precision="0" ProviderType="Decimal" Scale="0" Size="22" SourceColumn="NUMEROPRODUCTO" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="COSTO" Precision="0" ProviderType="Decimal" Scale="0" Size="22" SourceColumn="COSTO" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT        IDDOCUMENTO, NUMERO, NUMEROLINEA, IDPRODUCTO, TIPOSUBPROD, NUMEROREGISTRO, NUMEROPRODUCTO, COSTO
FROM            MOV_DESCRIPCIONDET</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE "MOV_DESCRIPCIONDET" SET "IDDOCUMENTO" = :IDDOCUMENTO, "NUMERO" = :NUMERO, "NUMEROLINEA" = :NUMEROLINEA, "IDPRODUCTO" = :IDPRODUCTO, "TIPOSUBPROD" = :TIPOSUBPROD, "NUMEROREGISTRO" = :NUMEROREGISTRO, "NUMEROPRODUCTO" = :NUMEROPRODUCTO, "COSTO" = :COSTO WHERE (("IDDOCUMENTO" = :Original_IDDOCUMENTO) AND ("NUMERO" = :Original_NUMERO) AND ("NUMEROLINEA" = :Original_NUMEROLINEA) AND ("IDPRODUCTO" = :Original_IDPRODUCTO) AND ("TIPOSUBPROD" = :Original_TIPOSUBPROD) AND ("NUMEROREGISTRO" = :Original_NUMEROREGISTRO) AND ((:IsNull_NUMEROPRODUCTO = 1 AND "NUMEROPRODUCTO" IS NULL) OR ("NUMEROPRODUCTO" = :Original_NUMEROPRODUCTO)) AND ((:IsNull_COSTO = 1 AND "COSTO" IS NULL) OR ("COSTO" = :Original_COSTO)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="IDDOCUMENTO" Precision="0" ProviderType="Varchar2" Scale="0" Size="5" SourceColumn="IDDOCUMENTO" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="NUMERO" Precision="0" ProviderType="Decimal" Scale="0" Size="22" SourceColumn="NUMERO" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="NUMEROLINEA" Precision="0" ProviderType="Decimal" Scale="0" Size="22" SourceColumn="NUMEROLINEA" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="IDPRODUCTO" Precision="0" ProviderType="Varchar2" Scale="0" Size="15" SourceColumn="IDPRODUCTO" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="TIPOSUBPROD" Precision="0" ProviderType="Decimal" Scale="0" Size="22" SourceColumn="TIPOSUBPROD" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="NUMEROREGISTRO" Precision="0" ProviderType="Varchar2" Scale="0" Size="20" SourceColumn="NUMEROREGISTRO" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="NUMEROPRODUCTO" Precision="0" ProviderType="Decimal" Scale="0" Size="22" SourceColumn="NUMEROPRODUCTO" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="COSTO" Precision="0" ProviderType="Decimal" Scale="0" Size="22" SourceColumn="COSTO" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_IDDOCUMENTO" Precision="0" ProviderType="Varchar2" Scale="0" Size="5" SourceColumn="IDDOCUMENTO" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="Original_NUMERO" Precision="0" ProviderType="Decimal" Scale="0" Size="22" SourceColumn="NUMERO" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="Original_NUMEROLINEA" Precision="0" ProviderType="Decimal" Scale="0" Size="22" SourceColumn="NUMEROLINEA" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_IDPRODUCTO" Precision="0" ProviderType="Varchar2" Scale="0" Size="15" SourceColumn="IDPRODUCTO" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="Original_TIPOSUBPROD" Precision="0" ProviderType="Decimal" Scale="0" Size="22" SourceColumn="TIPOSUBPROD" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_NUMEROREGISTRO" Precision="0" ProviderType="Varchar2" Scale="0" Size="20" SourceColumn="NUMEROREGISTRO" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_NUMEROPRODUCTO" Precision="0" ProviderType="Int32" Scale="0" Size="22" SourceColumn="NUMEROPRODUCTO" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="Original_NUMEROPRODUCTO" Precision="0" ProviderType="Decimal" Scale="0" Size="22" SourceColumn="NUMEROPRODUCTO" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_COSTO" Precision="0" ProviderType="Int32" Scale="0" Size="22" SourceColumn="COSTO" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="Original_COSTO" Precision="0" ProviderType="Decimal" Scale="0" Size="22" SourceColumn="COSTO" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="IDDOCUMENTO" DataSetColumn="IDDOCUMENTO" />
              <Mapping SourceColumn="NUMERO" DataSetColumn="NUMERO" />
              <Mapping SourceColumn="NUMEROLINEA" DataSetColumn="NUMEROLINEA" />
              <Mapping SourceColumn="IDPRODUCTO" DataSetColumn="IDPRODUCTO" />
              <Mapping SourceColumn="TIPOSUBPROD" DataSetColumn="TIPOSUBPROD" />
              <Mapping SourceColumn="NUMEROREGISTRO" DataSetColumn="NUMEROREGISTRO" />
              <Mapping SourceColumn="NUMEROPRODUCTO" DataSetColumn="NUMEROPRODUCTO" />
              <Mapping SourceColumn="COSTO" DataSetColumn="COSTO" />
            </Mappings>
            <Sources>
              <DbSource ConnectionRef="ConnectionString (MySettings)" DbObjectName="SAMUEL.MOV_DESCRIPCIONDET" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="FillByIdDocumentoNumero" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetDataByIdDocumentoNumero" GeneratorSourceName="FillByIdDocumentoNumero" GetMethodModifier="Public" GetMethodName="GetDataByIdDocumentoNumero" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataByIdDocumentoNumero" UserSourceName="FillByIdDocumentoNumero">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT COSTO, IDDOCUMENTO, IDPRODUCTO, NUMERO, NUMEROLINEA, NUMEROPRODUCTO, NUMEROREGISTRO, TIPOSUBPROD FROM MOV_DESCRIPCIONDET WHERE (IDDOCUMENTO = :PIDDOCUMENTO) AND (NUMERO = :PNUMERO) ORDER BY IDPRODUCTO, TIPOSUBPROD, NUMEROPRODUCTO</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="PIDDOCUMENTO" ColumnName="IDDOCUMENTO" DataSourceName="" DataTypeServer="VARCHAR2(5)" DbType="String" Direction="Input" ParameterName=":PIDDOCUMENTO" Precision="0" ProviderType="Varchar2" Scale="0" Size="5" SourceColumn="IDDOCUMENTO" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="PNUMERO" ColumnName="NUMERO" DataSourceName="" DataTypeServer="NUMBER(22)" DbType="Decimal" Direction="Input" ParameterName=":PNUMERO" Precision="38" ProviderType="Decimal" Scale="0" Size="22" SourceColumn="NUMERO" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </Sources>
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="MOV_DETALLENOTASCREDITOTableAdapter" GeneratorDataComponentClassName="MOV_DETALLENOTASCREDITOTableAdapter" Name="MOV_DETALLENOTASCREDITO" UserDataComponentName="MOV_DETALLENOTASCREDITOTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="ConnectionString (MySettings)" DbObjectName="SAMUEL.MOV_DETALLENOTASCREDITO" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM "SAMUEL"."MOV_DETALLENOTASCREDITO" WHERE (("IDDOCUMENTO" = :Original_IDDOCUMENTO) AND ("NUMERO" = :Original_NUMERO) AND ("NUMEROLINEA" = :Original_NUMEROLINEA) AND ((:IsNull_IDDOCFACTURA = 1 AND "IDDOCFACTURA" IS NULL) OR ("IDDOCFACTURA" = :Original_IDDOCFACTURA)) AND ((:IsNull_NUMEROFACTURA = 1 AND "NUMEROFACTURA" IS NULL) OR ("NUMEROFACTURA" = :Original_NUMEROFACTURA)) AND ((:IsNull_VALORNOTA = 1 AND "VALORNOTA" IS NULL) OR ("VALORNOTA" = :Original_VALORNOTA)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_IDDOCUMENTO" Precision="0" ProviderType="Varchar2" Scale="0" Size="5" SourceColumn="IDDOCUMENTO" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="Original_NUMERO" Precision="0" ProviderType="Decimal" Scale="0" Size="22" SourceColumn="NUMERO" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="Original_NUMEROLINEA" Precision="0" ProviderType="Decimal" Scale="0" Size="22" SourceColumn="NUMEROLINEA" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_IDDOCFACTURA" Precision="0" ProviderType="Int32" Scale="0" Size="5" SourceColumn="IDDOCFACTURA" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_IDDOCFACTURA" Precision="0" ProviderType="Varchar2" Scale="0" Size="5" SourceColumn="IDDOCFACTURA" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_NUMEROFACTURA" Precision="0" ProviderType="Int32" Scale="0" Size="22" SourceColumn="NUMEROFACTURA" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="Original_NUMEROFACTURA" Precision="0" ProviderType="Decimal" Scale="0" Size="22" SourceColumn="NUMEROFACTURA" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_VALORNOTA" Precision="0" ProviderType="Int32" Scale="0" Size="22" SourceColumn="VALORNOTA" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="Original_VALORNOTA" Precision="0" ProviderType="Decimal" Scale="0" Size="22" SourceColumn="VALORNOTA" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO "SAMUEL"."MOV_DETALLENOTASCREDITO" ("IDDOCUMENTO", "NUMERO", "NUMEROLINEA", "IDDOCFACTURA", "NUMEROFACTURA", "VALORNOTA") VALUES (:IDDOCUMENTO, :NUMERO, :NUMEROLINEA, :IDDOCFACTURA, :NUMEROFACTURA, :VALORNOTA)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="IDDOCUMENTO" Precision="0" ProviderType="Varchar2" Scale="0" Size="5" SourceColumn="IDDOCUMENTO" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="NUMERO" Precision="0" ProviderType="Decimal" Scale="0" Size="22" SourceColumn="NUMERO" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="NUMEROLINEA" Precision="0" ProviderType="Decimal" Scale="0" Size="22" SourceColumn="NUMEROLINEA" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="IDDOCFACTURA" Precision="0" ProviderType="Varchar2" Scale="0" Size="5" SourceColumn="IDDOCFACTURA" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="NUMEROFACTURA" Precision="0" ProviderType="Decimal" Scale="0" Size="22" SourceColumn="NUMEROFACTURA" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="VALORNOTA" Precision="0" ProviderType="Decimal" Scale="0" Size="22" SourceColumn="VALORNOTA" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT IDDOCUMENTO, NUMERO, NUMEROLINEA, IDDOCFACTURA, NUMEROFACTURA, VALORNOTA FROM SAMUEL.MOV_DETALLENOTASCREDITO</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE "SAMUEL"."MOV_DETALLENOTASCREDITO" SET "IDDOCUMENTO" = :IDDOCUMENTO, "NUMERO" = :NUMERO, "NUMEROLINEA" = :NUMEROLINEA, "IDDOCFACTURA" = :IDDOCFACTURA, "NUMEROFACTURA" = :NUMEROFACTURA, "VALORNOTA" = :VALORNOTA WHERE (("IDDOCUMENTO" = :Original_IDDOCUMENTO) AND ("NUMERO" = :Original_NUMERO) AND ("NUMEROLINEA" = :Original_NUMEROLINEA) AND ((:IsNull_IDDOCFACTURA = 1 AND "IDDOCFACTURA" IS NULL) OR ("IDDOCFACTURA" = :Original_IDDOCFACTURA)) AND ((:IsNull_NUMEROFACTURA = 1 AND "NUMEROFACTURA" IS NULL) OR ("NUMEROFACTURA" = :Original_NUMEROFACTURA)) AND ((:IsNull_VALORNOTA = 1 AND "VALORNOTA" IS NULL) OR ("VALORNOTA" = :Original_VALORNOTA)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="IDDOCUMENTO" Precision="0" ProviderType="Varchar2" Scale="0" Size="5" SourceColumn="IDDOCUMENTO" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="NUMERO" Precision="0" ProviderType="Decimal" Scale="0" Size="22" SourceColumn="NUMERO" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="NUMEROLINEA" Precision="0" ProviderType="Decimal" Scale="0" Size="22" SourceColumn="NUMEROLINEA" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="IDDOCFACTURA" Precision="0" ProviderType="Varchar2" Scale="0" Size="5" SourceColumn="IDDOCFACTURA" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="NUMEROFACTURA" Precision="0" ProviderType="Decimal" Scale="0" Size="22" SourceColumn="NUMEROFACTURA" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="VALORNOTA" Precision="0" ProviderType="Decimal" Scale="0" Size="22" SourceColumn="VALORNOTA" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_IDDOCUMENTO" Precision="0" ProviderType="Varchar2" Scale="0" Size="5" SourceColumn="IDDOCUMENTO" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="Original_NUMERO" Precision="0" ProviderType="Decimal" Scale="0" Size="22" SourceColumn="NUMERO" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="Original_NUMEROLINEA" Precision="0" ProviderType="Decimal" Scale="0" Size="22" SourceColumn="NUMEROLINEA" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_IDDOCFACTURA" Precision="0" ProviderType="Int32" Scale="0" Size="5" SourceColumn="IDDOCFACTURA" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_IDDOCFACTURA" Precision="0" ProviderType="Varchar2" Scale="0" Size="5" SourceColumn="IDDOCFACTURA" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_NUMEROFACTURA" Precision="0" ProviderType="Int32" Scale="0" Size="22" SourceColumn="NUMEROFACTURA" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="Original_NUMEROFACTURA" Precision="0" ProviderType="Decimal" Scale="0" Size="22" SourceColumn="NUMEROFACTURA" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_VALORNOTA" Precision="0" ProviderType="Int32" Scale="0" Size="22" SourceColumn="VALORNOTA" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="Original_VALORNOTA" Precision="0" ProviderType="Decimal" Scale="0" Size="22" SourceColumn="VALORNOTA" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="IDDOCUMENTO" DataSetColumn="IDDOCUMENTO" />
              <Mapping SourceColumn="NUMERO" DataSetColumn="NUMERO" />
              <Mapping SourceColumn="NUMEROLINEA" DataSetColumn="NUMEROLINEA" />
              <Mapping SourceColumn="IDDOCFACTURA" DataSetColumn="IDDOCFACTURA" />
              <Mapping SourceColumn="NUMEROFACTURA" DataSetColumn="NUMEROFACTURA" />
              <Mapping SourceColumn="VALORNOTA" DataSetColumn="VALORNOTA" />
            </Mappings>
            <Sources>
              <DbSource ConnectionRef="ConnectionString (MySettings)" DbObjectName="SAMUEL.MOV_DETALLENOTASCREDITO" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="FillByIdDocumento" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetDataByIdDocumento" GeneratorSourceName="FillByIdDocumento" GetMethodModifier="Public" GetMethodName="GetDataByIdDocumento" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataByIdDocumento" UserSourceName="FillByIdDocumento">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT IDDOCFACTURA, IDDOCUMENTO, NUMERO, NUMEROFACTURA, NUMEROLINEA, VALORNOTA FROM MOV_DETALLENOTASCREDITO WHERE (IDDOCUMENTO = :PIDDOC) AND (NUMERO = :PNUM)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="PIDDOC" ColumnName="IDDOCUMENTO" DataSourceName="" DataTypeServer="VARCHAR2(5)" DbType="String" Direction="Input" ParameterName=":PIDDOC" Precision="0" ProviderType="Varchar2" Scale="0" Size="5" SourceColumn="IDDOCUMENTO" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="PNUM" ColumnName="NUMERO" DataSourceName="" DataTypeServer="NUMBER(22)" DbType="Decimal" Direction="Input" ParameterName=":PNUM" Precision="0" ProviderType="Decimal" Scale="0" Size="22" SourceColumn="NUMERO" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </Sources>
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="MOV_DETALLENOTASDEBITOTableAdapter" GeneratorDataComponentClassName="MOV_DETALLENOTASDEBITOTableAdapter" Name="MOV_DETALLENOTASDEBITO" UserDataComponentName="MOV_DETALLENOTASDEBITOTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="ConnectionString (MySettings)" DbObjectName="SAMUEL.MOV_DETALLENOTASDEBITO" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM "SAMUEL"."MOV_DETALLENOTASDEBITO" WHERE (("IDDOCUMENTO" = :Original_IDDOCUMENTO) AND ("NUMERO" = :Original_NUMERO) AND ("NUMEROLINEA" = :Original_NUMEROLINEA) AND ("IDPRODUCTO" = :Original_IDPRODUCTO) AND ((:IsNull_TIPOSUBPROD = 1 AND "TIPOSUBPROD" IS NULL) OR ("TIPOSUBPROD" = :Original_TIPOSUBPROD)) AND ("NUMEROREGISTRO" = :Original_NUMEROREGISTRO) AND ((:IsNull_COSTOCOMPRA = 1 AND "COSTOCOMPRA" IS NULL) OR ("COSTOCOMPRA" = :Original_COSTOCOMPRA)) AND ((:IsNull_COSTOCOMCEL = 1 AND "COSTOCOMCEL" IS NULL) OR ("COSTOCOMCEL" = :Original_COSTOCOMCEL)) AND ((:IsNull_DIFERENCIA = 1 AND "DIFERENCIA" IS NULL) OR ("DIFERENCIA" = :Original_DIFERENCIA)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_IDDOCUMENTO" Precision="0" ProviderType="Varchar2" Scale="0" Size="5" SourceColumn="IDDOCUMENTO" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="Original_NUMERO" Precision="0" ProviderType="Decimal" Scale="0" Size="22" SourceColumn="NUMERO" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="Original_NUMEROLINEA" Precision="0" ProviderType="Decimal" Scale="0" Size="22" SourceColumn="NUMEROLINEA" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_IDPRODUCTO" Precision="0" ProviderType="Varchar2" Scale="0" Size="15" SourceColumn="IDPRODUCTO" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_TIPOSUBPROD" Precision="0" ProviderType="Int32" Scale="0" Size="22" SourceColumn="TIPOSUBPROD" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="Original_TIPOSUBPROD" Precision="0" ProviderType="Decimal" Scale="0" Size="22" SourceColumn="TIPOSUBPROD" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_NUMEROREGISTRO" Precision="0" ProviderType="Varchar2" Scale="0" Size="20" SourceColumn="NUMEROREGISTRO" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_COSTOCOMPRA" Precision="0" ProviderType="Int32" Scale="0" Size="22" SourceColumn="COSTOCOMPRA" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="Original_COSTOCOMPRA" Precision="0" ProviderType="Decimal" Scale="0" Size="22" SourceColumn="COSTOCOMPRA" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_COSTOCOMCEL" Precision="0" ProviderType="Int32" Scale="0" Size="22" SourceColumn="COSTOCOMCEL" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="Original_COSTOCOMCEL" Precision="0" ProviderType="Decimal" Scale="0" Size="22" SourceColumn="COSTOCOMCEL" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_DIFERENCIA" Precision="0" ProviderType="Int32" Scale="0" Size="22" SourceColumn="DIFERENCIA" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="Original_DIFERENCIA" Precision="0" ProviderType="Decimal" Scale="0" Size="22" SourceColumn="DIFERENCIA" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO "SAMUEL"."MOV_DETALLENOTASDEBITO" ("IDDOCUMENTO", "NUMERO", "NUMEROLINEA", "IDPRODUCTO", "TIPOSUBPROD", "NUMEROREGISTRO", "COSTOCOMPRA", "COSTOCOMCEL", "DIFERENCIA") VALUES (:IDDOCUMENTO, :NUMERO, :NUMEROLINEA, :IDPRODUCTO, :TIPOSUBPROD, :NUMEROREGISTRO, :COSTOCOMPRA, :COSTOCOMCEL, :DIFERENCIA)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="IDDOCUMENTO" Precision="0" ProviderType="Varchar2" Scale="0" Size="5" SourceColumn="IDDOCUMENTO" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="NUMERO" Precision="0" ProviderType="Decimal" Scale="0" Size="22" SourceColumn="NUMERO" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="NUMEROLINEA" Precision="0" ProviderType="Decimal" Scale="0" Size="22" SourceColumn="NUMEROLINEA" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="IDPRODUCTO" Precision="0" ProviderType="Varchar2" Scale="0" Size="15" SourceColumn="IDPRODUCTO" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="TIPOSUBPROD" Precision="0" ProviderType="Decimal" Scale="0" Size="22" SourceColumn="TIPOSUBPROD" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="NUMEROREGISTRO" Precision="0" ProviderType="Varchar2" Scale="0" Size="20" SourceColumn="NUMEROREGISTRO" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="COSTOCOMPRA" Precision="0" ProviderType="Decimal" Scale="0" Size="22" SourceColumn="COSTOCOMPRA" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="COSTOCOMCEL" Precision="0" ProviderType="Decimal" Scale="0" Size="22" SourceColumn="COSTOCOMCEL" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="DIFERENCIA" Precision="0" ProviderType="Decimal" Scale="0" Size="22" SourceColumn="DIFERENCIA" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT IDDOCUMENTO, NUMERO, NUMEROLINEA, IDPRODUCTO, TIPOSUBPROD, NUMEROREGISTRO, COSTOCOMPRA, COSTOCOMCEL, DIFERENCIA FROM SAMUEL.MOV_DETALLENOTASDEBITO</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE "SAMUEL"."MOV_DETALLENOTASDEBITO" SET "IDDOCUMENTO" = :IDDOCUMENTO, "NUMERO" = :NUMERO, "NUMEROLINEA" = :NUMEROLINEA, "IDPRODUCTO" = :IDPRODUCTO, "TIPOSUBPROD" = :TIPOSUBPROD, "NUMEROREGISTRO" = :NUMEROREGISTRO, "COSTOCOMPRA" = :COSTOCOMPRA, "COSTOCOMCEL" = :COSTOCOMCEL, "DIFERENCIA" = :DIFERENCIA WHERE (("IDDOCUMENTO" = :Original_IDDOCUMENTO) AND ("NUMERO" = :Original_NUMERO) AND ("NUMEROLINEA" = :Original_NUMEROLINEA) AND ("IDPRODUCTO" = :Original_IDPRODUCTO) AND ((:IsNull_TIPOSUBPROD = 1 AND "TIPOSUBPROD" IS NULL) OR ("TIPOSUBPROD" = :Original_TIPOSUBPROD)) AND ("NUMEROREGISTRO" = :Original_NUMEROREGISTRO) AND ((:IsNull_COSTOCOMPRA = 1 AND "COSTOCOMPRA" IS NULL) OR ("COSTOCOMPRA" = :Original_COSTOCOMPRA)) AND ((:IsNull_COSTOCOMCEL = 1 AND "COSTOCOMCEL" IS NULL) OR ("COSTOCOMCEL" = :Original_COSTOCOMCEL)) AND ((:IsNull_DIFERENCIA = 1 AND "DIFERENCIA" IS NULL) OR ("DIFERENCIA" = :Original_DIFERENCIA)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="IDDOCUMENTO" Precision="0" ProviderType="Varchar2" Scale="0" Size="5" SourceColumn="IDDOCUMENTO" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="NUMERO" Precision="0" ProviderType="Decimal" Scale="0" Size="22" SourceColumn="NUMERO" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="NUMEROLINEA" Precision="0" ProviderType="Decimal" Scale="0" Size="22" SourceColumn="NUMEROLINEA" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="IDPRODUCTO" Precision="0" ProviderType="Varchar2" Scale="0" Size="15" SourceColumn="IDPRODUCTO" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="TIPOSUBPROD" Precision="0" ProviderType="Decimal" Scale="0" Size="22" SourceColumn="TIPOSUBPROD" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="NUMEROREGISTRO" Precision="0" ProviderType="Varchar2" Scale="0" Size="20" SourceColumn="NUMEROREGISTRO" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="COSTOCOMPRA" Precision="0" ProviderType="Decimal" Scale="0" Size="22" SourceColumn="COSTOCOMPRA" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="COSTOCOMCEL" Precision="0" ProviderType="Decimal" Scale="0" Size="22" SourceColumn="COSTOCOMCEL" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="DIFERENCIA" Precision="0" ProviderType="Decimal" Scale="0" Size="22" SourceColumn="DIFERENCIA" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_IDDOCUMENTO" Precision="0" ProviderType="Varchar2" Scale="0" Size="5" SourceColumn="IDDOCUMENTO" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="Original_NUMERO" Precision="0" ProviderType="Decimal" Scale="0" Size="22" SourceColumn="NUMERO" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="Original_NUMEROLINEA" Precision="0" ProviderType="Decimal" Scale="0" Size="22" SourceColumn="NUMEROLINEA" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_IDPRODUCTO" Precision="0" ProviderType="Varchar2" Scale="0" Size="15" SourceColumn="IDPRODUCTO" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_TIPOSUBPROD" Precision="0" ProviderType="Int32" Scale="0" Size="22" SourceColumn="TIPOSUBPROD" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="Original_TIPOSUBPROD" Precision="0" ProviderType="Decimal" Scale="0" Size="22" SourceColumn="TIPOSUBPROD" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_NUMEROREGISTRO" Precision="0" ProviderType="Varchar2" Scale="0" Size="20" SourceColumn="NUMEROREGISTRO" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_COSTOCOMPRA" Precision="0" ProviderType="Int32" Scale="0" Size="22" SourceColumn="COSTOCOMPRA" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="Original_COSTOCOMPRA" Precision="0" ProviderType="Decimal" Scale="0" Size="22" SourceColumn="COSTOCOMPRA" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_COSTOCOMCEL" Precision="0" ProviderType="Int32" Scale="0" Size="22" SourceColumn="COSTOCOMCEL" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="Original_COSTOCOMCEL" Precision="0" ProviderType="Decimal" Scale="0" Size="22" SourceColumn="COSTOCOMCEL" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_DIFERENCIA" Precision="0" ProviderType="Int32" Scale="0" Size="22" SourceColumn="DIFERENCIA" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="Original_DIFERENCIA" Precision="0" ProviderType="Decimal" Scale="0" Size="22" SourceColumn="DIFERENCIA" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="IDDOCUMENTO" DataSetColumn="IDDOCUMENTO" />
              <Mapping SourceColumn="NUMERO" DataSetColumn="NUMERO" />
              <Mapping SourceColumn="NUMEROLINEA" DataSetColumn="NUMEROLINEA" />
              <Mapping SourceColumn="IDPRODUCTO" DataSetColumn="IDPRODUCTO" />
              <Mapping SourceColumn="TIPOSUBPROD" DataSetColumn="TIPOSUBPROD" />
              <Mapping SourceColumn="NUMEROREGISTRO" DataSetColumn="NUMEROREGISTRO" />
              <Mapping SourceColumn="COSTOCOMPRA" DataSetColumn="COSTOCOMPRA" />
              <Mapping SourceColumn="COSTOCOMCEL" DataSetColumn="COSTOCOMCEL" />
              <Mapping SourceColumn="DIFERENCIA" DataSetColumn="DIFERENCIA" />
            </Mappings>
            <Sources>
              <DbSource ConnectionRef="ConnectionString (MySettings)" DbObjectName="SAMUEL.MOV_DETALLENOTASDEBITO" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="FillByIdDocNumero" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetDataByIdDocNumero" GeneratorSourceName="FillByIdDocNumero" GetMethodModifier="Public" GetMethodName="GetDataByIdDocNumero" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataByIdDocNumero" UserSourceName="FillByIdDocNumero">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT COSTOCOMCEL, COSTOCOMPRA, DIFERENCIA, IDDOCUMENTO, IDPRODUCTO, NUMERO, NUMEROLINEA, NUMEROREGISTRO, TIPOSUBPROD FROM MOV_DETALLENOTASDEBITO WHERE (IDDOCUMENTO = :IDDOC) AND (NUMERO = :NUMERODOC)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="IDDOC" ColumnName="IDDOCUMENTO" DataSourceName="" DataTypeServer="VARCHAR2(5)" DbType="String" Direction="Input" ParameterName=":IDDOC" Precision="0" ProviderType="Varchar2" Scale="0" Size="5" SourceColumn="IDDOCUMENTO" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="NUMERODOC" ColumnName="NUMERO" DataSourceName="" DataTypeServer="NUMBER(22)" DbType="Decimal" Direction="Input" ParameterName=":NUMERODOC" Precision="38" ProviderType="Decimal" Scale="0" Size="22" SourceColumn="NUMERO" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </Sources>
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="MOV_PLANTableAdapter" GeneratorDataComponentClassName="MOV_PLANTableAdapter" Name="MOV_PLAN" UserDataComponentName="MOV_PLANTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="ConnectionString (MySettings)" DbObjectName="SAMUEL.MOV_PLAN" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM "SAMUEL"."MOV_PLAN" WHERE (("IDDOCUMENTO" = :Original_IDDOCUMENTO) AND ("NUMERO" = :Original_NUMERO) AND ((:IsNull_FECHADOCUMENTO = 1 AND "FECHADOCUMENTO" IS NULL) OR ("FECHADOCUMENTO" = :Original_FECHADOCUMENTO)) AND ((:IsNull_IDCANAL = 1 AND "IDCANAL" IS NULL) OR ("IDCANAL" = :Original_IDCANAL)) AND ((:IsNull_IDCCOSTO = 1 AND "IDCCOSTO" IS NULL) OR ("IDCCOSTO" = :Original_IDCCOSTO)) AND ((:IsNull_IDLISTA = 1 AND "IDLISTA" IS NULL) OR ("IDLISTA" = :Original_IDLISTA)) AND ((:IsNull_IDSEDE = 1 AND "IDSEDE" IS NULL) OR ("IDSEDE" = :Original_IDSEDE)) AND ((:IsNull_IDTERCERO = 1 AND "IDTERCERO" IS NULL) OR ("IDTERCERO" = :Original_IDTERCERO)) AND ((:IsNull_SUCURSAL = 1 AND "SUCURSAL" IS NULL) OR ("SUCURSAL" = :Original_SUCURSAL)) AND ((:IsNull_IDFORMAPAGO = 1 AND "IDFORMAPAGO" IS NULL) OR ("IDFORMAPAGO" = :Original_IDFORMAPAGO)) AND ((:IsNull_IDCAJA = 1 AND "IDCAJA" IS NULL) OR ("IDCAJA" = :Original_IDCAJA)) AND ((:IsNull_IDBODEGAORIGEN = 1 AND "IDBODEGAORIGEN" IS NULL) OR ("IDBODEGAORIGEN" = :Original_IDBODEGAORIGEN)) AND ((:IsNull_IDVENDEDOR = 1 AND "IDVENDEDOR" IS NULL) OR ("IDVENDEDOR" = :Original_IDVENDEDOR)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_IDDOCUMENTO" Precision="0" ProviderType="Varchar2" Scale="0" Size="5" SourceColumn="IDDOCUMENTO" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="Original_NUMERO" Precision="0" ProviderType="Decimal" Scale="0" Size="22" SourceColumn="NUMERO" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_FECHADOCUMENTO" Precision="0" ProviderType="Int32" Scale="0" Size="7" SourceColumn="FECHADOCUMENTO" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Date" Direction="Input" ParameterName="Original_FECHADOCUMENTO" Precision="0" ProviderType="Date" Scale="0" Size="7" SourceColumn="FECHADOCUMENTO" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_IDCANAL" Precision="0" ProviderType="Int32" Scale="0" Size="5" SourceColumn="IDCANAL" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_IDCANAL" Precision="0" ProviderType="Varchar2" Scale="0" Size="5" SourceColumn="IDCANAL" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_IDCCOSTO" Precision="0" ProviderType="Int32" Scale="0" Size="5" SourceColumn="IDCCOSTO" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_IDCCOSTO" Precision="0" ProviderType="Varchar2" Scale="0" Size="5" SourceColumn="IDCCOSTO" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_IDLISTA" Precision="0" ProviderType="Int32" Scale="0" Size="5" SourceColumn="IDLISTA" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_IDLISTA" Precision="0" ProviderType="Varchar2" Scale="0" Size="5" SourceColumn="IDLISTA" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_IDSEDE" Precision="0" ProviderType="Int32" Scale="0" Size="5" SourceColumn="IDSEDE" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_IDSEDE" Precision="0" ProviderType="Varchar2" Scale="0" Size="5" SourceColumn="IDSEDE" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_IDTERCERO" Precision="0" ProviderType="Int32" Scale="0" Size="15" SourceColumn="IDTERCERO" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_IDTERCERO" Precision="0" ProviderType="Varchar2" Scale="0" Size="15" SourceColumn="IDTERCERO" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_SUCURSAL" Precision="0" ProviderType="Int32" Scale="0" Size="22" SourceColumn="SUCURSAL" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="Original_SUCURSAL" Precision="0" ProviderType="Decimal" Scale="0" Size="22" SourceColumn="SUCURSAL" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_IDFORMAPAGO" Precision="0" ProviderType="Int32" Scale="0" Size="5" SourceColumn="IDFORMAPAGO" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_IDFORMAPAGO" Precision="0" ProviderType="Varchar2" Scale="0" Size="5" SourceColumn="IDFORMAPAGO" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_IDCAJA" Precision="0" ProviderType="Int32" Scale="0" Size="5" SourceColumn="IDCAJA" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_IDCAJA" Precision="0" ProviderType="Varchar2" Scale="0" Size="5" SourceColumn="IDCAJA" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_IDBODEGAORIGEN" Precision="0" ProviderType="Int32" Scale="0" Size="5" SourceColumn="IDBODEGAORIGEN" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_IDBODEGAORIGEN" Precision="0" ProviderType="Varchar2" Scale="0" Size="5" SourceColumn="IDBODEGAORIGEN" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_IDVENDEDOR" Precision="0" ProviderType="Int32" Scale="0" Size="15" SourceColumn="IDVENDEDOR" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_IDVENDEDOR" Precision="0" ProviderType="Varchar2" Scale="0" Size="15" SourceColumn="IDVENDEDOR" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO "SAMUEL"."MOV_PLAN" ("IDDOCUMENTO", "NUMERO", "FECHADOCUMENTO", "IDCANAL", "IDCCOSTO", "IDLISTA", "IDSEDE", "IDTERCERO", "SUCURSAL", "IDFORMAPAGO", "IDCAJA", "IDBODEGAORIGEN", "IDVENDEDOR") VALUES (:IDDOCUMENTO, :NUMERO, :FECHADOCUMENTO, :IDCANAL, :IDCCOSTO, :IDLISTA, :IDSEDE, :IDTERCERO, :SUCURSAL, :IDFORMAPAGO, :IDCAJA, :IDBODEGAORIGEN, :IDVENDEDOR)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="IDDOCUMENTO" Precision="0" ProviderType="Varchar2" Scale="0" Size="5" SourceColumn="IDDOCUMENTO" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="NUMERO" Precision="0" ProviderType="Decimal" Scale="0" Size="22" SourceColumn="NUMERO" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Date" Direction="Input" ParameterName="FECHADOCUMENTO" Precision="0" ProviderType="Date" Scale="0" Size="7" SourceColumn="FECHADOCUMENTO" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="IDCANAL" Precision="0" ProviderType="Varchar2" Scale="0" Size="5" SourceColumn="IDCANAL" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="IDCCOSTO" Precision="0" ProviderType="Varchar2" Scale="0" Size="5" SourceColumn="IDCCOSTO" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="IDLISTA" Precision="0" ProviderType="Varchar2" Scale="0" Size="5" SourceColumn="IDLISTA" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="IDSEDE" Precision="0" ProviderType="Varchar2" Scale="0" Size="5" SourceColumn="IDSEDE" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="IDTERCERO" Precision="0" ProviderType="Varchar2" Scale="0" Size="15" SourceColumn="IDTERCERO" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="SUCURSAL" Precision="0" ProviderType="Decimal" Scale="0" Size="22" SourceColumn="SUCURSAL" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="IDFORMAPAGO" Precision="0" ProviderType="Varchar2" Scale="0" Size="5" SourceColumn="IDFORMAPAGO" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="IDCAJA" Precision="0" ProviderType="Varchar2" Scale="0" Size="5" SourceColumn="IDCAJA" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="IDBODEGAORIGEN" Precision="0" ProviderType="Varchar2" Scale="0" Size="5" SourceColumn="IDBODEGAORIGEN" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="IDVENDEDOR" Precision="0" ProviderType="Varchar2" Scale="0" Size="15" SourceColumn="IDVENDEDOR" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT IDDOCUMENTO, NUMERO, FECHADOCUMENTO, IDCANAL, IDCCOSTO, IDLISTA, IDSEDE, IDTERCERO, SUCURSAL, IDFORMAPAGO, IDCAJA, IDBODEGAORIGEN, IDVENDEDOR FROM SAMUEL.MOV_PLAN</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE "SAMUEL"."MOV_PLAN" SET "IDDOCUMENTO" = :IDDOCUMENTO, "NUMERO" = :NUMERO, "FECHADOCUMENTO" = :FECHADOCUMENTO, "IDCANAL" = :IDCANAL, "IDCCOSTO" = :IDCCOSTO, "IDLISTA" = :IDLISTA, "IDSEDE" = :IDSEDE, "IDTERCERO" = :IDTERCERO, "SUCURSAL" = :SUCURSAL, "IDFORMAPAGO" = :IDFORMAPAGO, "IDCAJA" = :IDCAJA, "IDBODEGAORIGEN" = :IDBODEGAORIGEN, "IDVENDEDOR" = :IDVENDEDOR WHERE (("IDDOCUMENTO" = :Original_IDDOCUMENTO) AND ("NUMERO" = :Original_NUMERO) AND ((:IsNull_FECHADOCUMENTO = 1 AND "FECHADOCUMENTO" IS NULL) OR ("FECHADOCUMENTO" = :Original_FECHADOCUMENTO)) AND ((:IsNull_IDCANAL = 1 AND "IDCANAL" IS NULL) OR ("IDCANAL" = :Original_IDCANAL)) AND ((:IsNull_IDCCOSTO = 1 AND "IDCCOSTO" IS NULL) OR ("IDCCOSTO" = :Original_IDCCOSTO)) AND ((:IsNull_IDLISTA = 1 AND "IDLISTA" IS NULL) OR ("IDLISTA" = :Original_IDLISTA)) AND ((:IsNull_IDSEDE = 1 AND "IDSEDE" IS NULL) OR ("IDSEDE" = :Original_IDSEDE)) AND ((:IsNull_IDTERCERO = 1 AND "IDTERCERO" IS NULL) OR ("IDTERCERO" = :Original_IDTERCERO)) AND ((:IsNull_SUCURSAL = 1 AND "SUCURSAL" IS NULL) OR ("SUCURSAL" = :Original_SUCURSAL)) AND ((:IsNull_IDFORMAPAGO = 1 AND "IDFORMAPAGO" IS NULL) OR ("IDFORMAPAGO" = :Original_IDFORMAPAGO)) AND ((:IsNull_IDCAJA = 1 AND "IDCAJA" IS NULL) OR ("IDCAJA" = :Original_IDCAJA)) AND ((:IsNull_IDBODEGAORIGEN = 1 AND "IDBODEGAORIGEN" IS NULL) OR ("IDBODEGAORIGEN" = :Original_IDBODEGAORIGEN)) AND ((:IsNull_IDVENDEDOR = 1 AND "IDVENDEDOR" IS NULL) OR ("IDVENDEDOR" = :Original_IDVENDEDOR)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="IDDOCUMENTO" Precision="0" ProviderType="Varchar2" Scale="0" Size="5" SourceColumn="IDDOCUMENTO" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="NUMERO" Precision="0" ProviderType="Decimal" Scale="0" Size="22" SourceColumn="NUMERO" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Date" Direction="Input" ParameterName="FECHADOCUMENTO" Precision="0" ProviderType="Date" Scale="0" Size="7" SourceColumn="FECHADOCUMENTO" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="IDCANAL" Precision="0" ProviderType="Varchar2" Scale="0" Size="5" SourceColumn="IDCANAL" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="IDCCOSTO" Precision="0" ProviderType="Varchar2" Scale="0" Size="5" SourceColumn="IDCCOSTO" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="IDLISTA" Precision="0" ProviderType="Varchar2" Scale="0" Size="5" SourceColumn="IDLISTA" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="IDSEDE" Precision="0" ProviderType="Varchar2" Scale="0" Size="5" SourceColumn="IDSEDE" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="IDTERCERO" Precision="0" ProviderType="Varchar2" Scale="0" Size="15" SourceColumn="IDTERCERO" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="SUCURSAL" Precision="0" ProviderType="Decimal" Scale="0" Size="22" SourceColumn="SUCURSAL" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="IDFORMAPAGO" Precision="0" ProviderType="Varchar2" Scale="0" Size="5" SourceColumn="IDFORMAPAGO" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="IDCAJA" Precision="0" ProviderType="Varchar2" Scale="0" Size="5" SourceColumn="IDCAJA" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="IDBODEGAORIGEN" Precision="0" ProviderType="Varchar2" Scale="0" Size="5" SourceColumn="IDBODEGAORIGEN" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="IDVENDEDOR" Precision="0" ProviderType="Varchar2" Scale="0" Size="15" SourceColumn="IDVENDEDOR" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_IDDOCUMENTO" Precision="0" ProviderType="Varchar2" Scale="0" Size="5" SourceColumn="IDDOCUMENTO" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="Original_NUMERO" Precision="0" ProviderType="Decimal" Scale="0" Size="22" SourceColumn="NUMERO" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_FECHADOCUMENTO" Precision="0" ProviderType="Int32" Scale="0" Size="7" SourceColumn="FECHADOCUMENTO" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Date" Direction="Input" ParameterName="Original_FECHADOCUMENTO" Precision="0" ProviderType="Date" Scale="0" Size="7" SourceColumn="FECHADOCUMENTO" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_IDCANAL" Precision="0" ProviderType="Int32" Scale="0" Size="5" SourceColumn="IDCANAL" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_IDCANAL" Precision="0" ProviderType="Varchar2" Scale="0" Size="5" SourceColumn="IDCANAL" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_IDCCOSTO" Precision="0" ProviderType="Int32" Scale="0" Size="5" SourceColumn="IDCCOSTO" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_IDCCOSTO" Precision="0" ProviderType="Varchar2" Scale="0" Size="5" SourceColumn="IDCCOSTO" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_IDLISTA" Precision="0" ProviderType="Int32" Scale="0" Size="5" SourceColumn="IDLISTA" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_IDLISTA" Precision="0" ProviderType="Varchar2" Scale="0" Size="5" SourceColumn="IDLISTA" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_IDSEDE" Precision="0" ProviderType="Int32" Scale="0" Size="5" SourceColumn="IDSEDE" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_IDSEDE" Precision="0" ProviderType="Varchar2" Scale="0" Size="5" SourceColumn="IDSEDE" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_IDTERCERO" Precision="0" ProviderType="Int32" Scale="0" Size="15" SourceColumn="IDTERCERO" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_IDTERCERO" Precision="0" ProviderType="Varchar2" Scale="0" Size="15" SourceColumn="IDTERCERO" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_SUCURSAL" Precision="0" ProviderType="Int32" Scale="0" Size="22" SourceColumn="SUCURSAL" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="Original_SUCURSAL" Precision="0" ProviderType="Decimal" Scale="0" Size="22" SourceColumn="SUCURSAL" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_IDFORMAPAGO" Precision="0" ProviderType="Int32" Scale="0" Size="5" SourceColumn="IDFORMAPAGO" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_IDFORMAPAGO" Precision="0" ProviderType="Varchar2" Scale="0" Size="5" SourceColumn="IDFORMAPAGO" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_IDCAJA" Precision="0" ProviderType="Int32" Scale="0" Size="5" SourceColumn="IDCAJA" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_IDCAJA" Precision="0" ProviderType="Varchar2" Scale="0" Size="5" SourceColumn="IDCAJA" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_IDBODEGAORIGEN" Precision="0" ProviderType="Int32" Scale="0" Size="5" SourceColumn="IDBODEGAORIGEN" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_IDBODEGAORIGEN" Precision="0" ProviderType="Varchar2" Scale="0" Size="5" SourceColumn="IDBODEGAORIGEN" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_IDVENDEDOR" Precision="0" ProviderType="Int32" Scale="0" Size="15" SourceColumn="IDVENDEDOR" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_IDVENDEDOR" Precision="0" ProviderType="Varchar2" Scale="0" Size="15" SourceColumn="IDVENDEDOR" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="IDDOCUMENTO" DataSetColumn="IDDOCUMENTO" />
              <Mapping SourceColumn="NUMERO" DataSetColumn="NUMERO" />
              <Mapping SourceColumn="FECHADOCUMENTO" DataSetColumn="FECHADOCUMENTO" />
              <Mapping SourceColumn="IDCANAL" DataSetColumn="IDCANAL" />
              <Mapping SourceColumn="IDCCOSTO" DataSetColumn="IDCCOSTO" />
              <Mapping SourceColumn="IDLISTA" DataSetColumn="IDLISTA" />
              <Mapping SourceColumn="IDSEDE" DataSetColumn="IDSEDE" />
              <Mapping SourceColumn="IDTERCERO" DataSetColumn="IDTERCERO" />
              <Mapping SourceColumn="SUCURSAL" DataSetColumn="SUCURSAL" />
              <Mapping SourceColumn="IDFORMAPAGO" DataSetColumn="IDFORMAPAGO" />
              <Mapping SourceColumn="IDCAJA" DataSetColumn="IDCAJA" />
              <Mapping SourceColumn="IDBODEGAORIGEN" DataSetColumn="IDBODEGAORIGEN" />
              <Mapping SourceColumn="IDVENDEDOR" DataSetColumn="IDVENDEDOR" />
            </Mappings>
            <Sources>
              <DbSource ConnectionRef="ConnectionString (MySettings)" DbObjectName="SAMUEL.MOV_PLAN" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="FillByIdDocumentoNumero" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetDataByIdDocumentoNumero" GeneratorSourceName="FillByIdDocumentoNumero" GetMethodModifier="Public" GetMethodName="GetDataByIdDocumentoNumero" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataByIdDocumentoNumero" UserSourceName="FillByIdDocumentoNumero">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT FECHADOCUMENTO, IDBODEGAORIGEN, IDCAJA, IDCANAL, IDCCOSTO, IDDOCUMENTO, IDFORMAPAGO, IDLISTA, IDSEDE, IDTERCERO, IDVENDEDOR, NUMERO, SUCURSAL FROM MOV_PLAN WHERE (IDDOCUMENTO = :PIDDOCUMENTO) AND (NUMERO = :PNUMERO)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="PIDDOCUMENTO" ColumnName="IDDOCUMENTO" DataSourceName="" DataTypeServer="NVARCHAR2(5)" DbType="String" Direction="Input" ParameterName=":PIDDOCUMENTO" Precision="0" ProviderType="Varchar2" Scale="0" Size="5" SourceColumn="IDDOCUMENTO" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="PNUMERO" ColumnName="NUMERO" DataSourceName="" DataTypeServer="NUMBER(22)" DbType="Decimal" Direction="Input" ParameterName=":PNUMERO" Precision="38" ProviderType="Decimal" Scale="0" Size="22" SourceColumn="NUMERO" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </Sources>
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="MOV_PLANDETALLETableAdapter" GeneratorDataComponentClassName="MOV_PLANDETALLETableAdapter" Name="MOV_PLANDETALLE" UserDataComponentName="MOV_PLANDETALLETableAdapter">
            <MainSource>
              <DbSource ConnectionRef="ConnectionString (MySettings)" DbObjectName="SAMUEL.MOV_PLANDETALLE" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM "MOV_PLANDETALLE" WHERE (("IDDOCUMENTO" = :Original_IDDOCUMENTO) AND ("NUMERO" = :Original_NUMERO) AND ("NUMEROLINEA" = :Original_NUMEROLINEA) AND ("IDPLAN" = :Original_IDPLAN) AND ((:IsNull_IMEI = 1 AND "IMEI" IS NULL) OR ("IMEI" = :Original_IMEI)) AND ((:IsNull_ICCID = 1 AND "ICCID" IS NULL) OR ("ICCID" = :Original_ICCID)) AND ((:IsNull_MIND = 1 AND "MIND" IS NULL) OR ("MIND" = :Original_MIND)) AND ((:IsNull_VALOR = 1 AND "VALOR" IS NULL) OR ("VALOR" = :Original_VALOR)) AND ((:IsNull_ANTICIPO = 1 AND "ANTICIPO" IS NULL) OR ("ANTICIPO" = :Original_ANTICIPO)) AND ((:IsNull_ACTIVO = 1 AND "ACTIVO" IS NULL) OR ("ACTIVO" = :Original_ACTIVO)) AND ("VALORBASEIMEI" = :Original_VALORBASEIMEI) AND ("VALORIVAIMEI" = :Original_VALORIVAIMEI) AND ("VALORBASEICCID" = :Original_VALORBASEICCID) AND ("VALORIVAICCID" = :Original_VALORIVAICCID) AND ((:IsNull_IDPRODUCTOIMEI = 1 AND "IDPRODUCTOIMEI" IS NULL) OR ("IDPRODUCTOIMEI" = :Original_IDPRODUCTOIMEI)) AND ((:IsNull_IDPRODUCTOICCID = 1 AND "IDPRODUCTOICCID" IS NULL) OR ("IDPRODUCTOICCID" = :Original_IDPRODUCTOICCID)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_IDDOCUMENTO" Precision="0" ProviderType="Varchar2" Scale="0" Size="5" SourceColumn="IDDOCUMENTO" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="Original_NUMERO" Precision="0" ProviderType="Decimal" Scale="0" Size="22" SourceColumn="NUMERO" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="Original_NUMEROLINEA" Precision="0" ProviderType="Decimal" Scale="0" Size="22" SourceColumn="NUMEROLINEA" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_IDPLAN" Precision="0" ProviderType="Varchar2" Scale="0" Size="5" SourceColumn="IDPLAN" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_IMEI" Precision="0" ProviderType="Int32" Scale="0" Size="20" SourceColumn="IMEI" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_IMEI" Precision="0" ProviderType="Varchar2" Scale="0" Size="20" SourceColumn="IMEI" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_ICCID" Precision="0" ProviderType="Int32" Scale="0" Size="20" SourceColumn="ICCID" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_ICCID" Precision="0" ProviderType="Varchar2" Scale="0" Size="20" SourceColumn="ICCID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_MIND" Precision="0" ProviderType="Int32" Scale="0" Size="20" SourceColumn="MIND" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_MIND" Precision="0" ProviderType="Varchar2" Scale="0" Size="20" SourceColumn="MIND" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_VALOR" Precision="0" ProviderType="Int32" Scale="0" Size="22" SourceColumn="VALOR" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="Original_VALOR" Precision="0" ProviderType="Decimal" Scale="0" Size="22" SourceColumn="VALOR" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_ANTICIPO" Precision="0" ProviderType="Int32" Scale="0" Size="22" SourceColumn="ANTICIPO" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="Original_ANTICIPO" Precision="0" ProviderType="Decimal" Scale="0" Size="22" SourceColumn="ANTICIPO" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_ACTIVO" Precision="0" ProviderType="Int32" Scale="0" Size="1" SourceColumn="ACTIVO" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="Original_ACTIVO" Precision="0" ProviderType="Char" Scale="0" Size="1" SourceColumn="ACTIVO" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="Original_VALORBASEIMEI" Precision="0" ProviderType="Decimal" Scale="0" Size="22" SourceColumn="VALORBASEIMEI" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="Original_VALORIVAIMEI" Precision="0" ProviderType="Decimal" Scale="0" Size="22" SourceColumn="VALORIVAIMEI" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="Original_VALORBASEICCID" Precision="0" ProviderType="Decimal" Scale="0" Size="22" SourceColumn="VALORBASEICCID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="Original_VALORIVAICCID" Precision="0" ProviderType="Decimal" Scale="0" Size="22" SourceColumn="VALORIVAICCID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_IDPRODUCTOIMEI" Precision="0" ProviderType="Int32" Scale="0" Size="15" SourceColumn="IDPRODUCTOIMEI" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_IDPRODUCTOIMEI" Precision="0" ProviderType="Varchar2" Scale="0" Size="15" SourceColumn="IDPRODUCTOIMEI" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_IDPRODUCTOICCID" Precision="0" ProviderType="Int32" Scale="0" Size="15" SourceColumn="IDPRODUCTOICCID" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_IDPRODUCTOICCID" Precision="0" ProviderType="Varchar2" Scale="0" Size="15" SourceColumn="IDPRODUCTOICCID" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO "MOV_PLANDETALLE" ("IDDOCUMENTO", "NUMERO", "NUMEROLINEA", "IDPLAN", "IMEI", "ICCID", "MIND", "VALOR", "ANTICIPO", "ACTIVO", "VALORBASEIMEI", "VALORIVAIMEI", "VALORBASEICCID", "VALORIVAICCID", "IDPRODUCTOIMEI", "IDPRODUCTOICCID") VALUES (:IDDOCUMENTO, :NUMERO, :NUMEROLINEA, :IDPLAN, :IMEI, :ICCID, :MIND, :VALOR, :ANTICIPO, :ACTIVO, :VALORBASEIMEI, :VALORIVAIMEI, :VALORBASEICCID, :VALORIVAICCID, :IDPRODUCTOIMEI, :IDPRODUCTOICCID)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="IDDOCUMENTO" Precision="0" ProviderType="Varchar2" Scale="0" Size="5" SourceColumn="IDDOCUMENTO" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="NUMERO" Precision="0" ProviderType="Decimal" Scale="0" Size="22" SourceColumn="NUMERO" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="NUMEROLINEA" Precision="0" ProviderType="Decimal" Scale="0" Size="22" SourceColumn="NUMEROLINEA" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="IDPLAN" Precision="0" ProviderType="Varchar2" Scale="0" Size="5" SourceColumn="IDPLAN" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="IMEI" Precision="0" ProviderType="Varchar2" Scale="0" Size="20" SourceColumn="IMEI" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="ICCID" Precision="0" ProviderType="Varchar2" Scale="0" Size="20" SourceColumn="ICCID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="MIND" Precision="0" ProviderType="Varchar2" Scale="0" Size="20" SourceColumn="MIND" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="VALOR" Precision="0" ProviderType="Decimal" Scale="0" Size="22" SourceColumn="VALOR" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="ANTICIPO" Precision="0" ProviderType="Decimal" Scale="0" Size="22" SourceColumn="ANTICIPO" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="ACTIVO" Precision="0" ProviderType="Char" Scale="0" Size="1" SourceColumn="ACTIVO" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="VALORBASEIMEI" Precision="0" ProviderType="Decimal" Scale="0" Size="22" SourceColumn="VALORBASEIMEI" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="VALORIVAIMEI" Precision="0" ProviderType="Decimal" Scale="0" Size="22" SourceColumn="VALORIVAIMEI" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="VALORBASEICCID" Precision="0" ProviderType="Decimal" Scale="0" Size="22" SourceColumn="VALORBASEICCID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="VALORIVAICCID" Precision="0" ProviderType="Decimal" Scale="0" Size="22" SourceColumn="VALORIVAICCID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="IDPRODUCTOIMEI" Precision="0" ProviderType="Varchar2" Scale="0" Size="15" SourceColumn="IDPRODUCTOIMEI" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="IDPRODUCTOICCID" Precision="0" ProviderType="Varchar2" Scale="0" Size="15" SourceColumn="IDPRODUCTOICCID" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT        IDDOCUMENTO, NUMERO, NUMEROLINEA, IDPLAN, IMEI, ICCID, MIND, VALOR, ANTICIPO, ACTIVO, VALORBASEIMEI, VALORIVAIMEI, VALORBASEICCID, 
                         VALORIVAICCID, IDPRODUCTOIMEI, IDPRODUCTOICCID
FROM            MOV_PLANDETALLE</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE "MOV_PLANDETALLE" SET "IDDOCUMENTO" = :IDDOCUMENTO, "NUMERO" = :NUMERO, "NUMEROLINEA" = :NUMEROLINEA, "IDPLAN" = :IDPLAN, "IMEI" = :IMEI, "ICCID" = :ICCID, "MIND" = :MIND, "VALOR" = :VALOR, "ANTICIPO" = :ANTICIPO, "ACTIVO" = :ACTIVO, "VALORBASEIMEI" = :VALORBASEIMEI, "VALORIVAIMEI" = :VALORIVAIMEI, "VALORBASEICCID" = :VALORBASEICCID, "VALORIVAICCID" = :VALORIVAICCID, "IDPRODUCTOIMEI" = :IDPRODUCTOIMEI, "IDPRODUCTOICCID" = :IDPRODUCTOICCID WHERE (("IDDOCUMENTO" = :Original_IDDOCUMENTO) AND ("NUMERO" = :Original_NUMERO) AND ("NUMEROLINEA" = :Original_NUMEROLINEA) AND ("IDPLAN" = :Original_IDPLAN) AND ((:IsNull_IMEI = 1 AND "IMEI" IS NULL) OR ("IMEI" = :Original_IMEI)) AND ((:IsNull_ICCID = 1 AND "ICCID" IS NULL) OR ("ICCID" = :Original_ICCID)) AND ((:IsNull_MIND = 1 AND "MIND" IS NULL) OR ("MIND" = :Original_MIND)) AND ((:IsNull_VALOR = 1 AND "VALOR" IS NULL) OR ("VALOR" = :Original_VALOR)) AND ((:IsNull_ANTICIPO = 1 AND "ANTICIPO" IS NULL) OR ("ANTICIPO" = :Original_ANTICIPO)) AND ((:IsNull_ACTIVO = 1 AND "ACTIVO" IS NULL) OR ("ACTIVO" = :Original_ACTIVO)) AND ("VALORBASEIMEI" = :Original_VALORBASEIMEI) AND ("VALORIVAIMEI" = :Original_VALORIVAIMEI) AND ("VALORBASEICCID" = :Original_VALORBASEICCID) AND ("VALORIVAICCID" = :Original_VALORIVAICCID) AND ((:IsNull_IDPRODUCTOIMEI = 1 AND "IDPRODUCTOIMEI" IS NULL) OR ("IDPRODUCTOIMEI" = :Original_IDPRODUCTOIMEI)) AND ((:IsNull_IDPRODUCTOICCID = 1 AND "IDPRODUCTOICCID" IS NULL) OR ("IDPRODUCTOICCID" = :Original_IDPRODUCTOICCID)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="IDDOCUMENTO" Precision="0" ProviderType="Varchar2" Scale="0" Size="5" SourceColumn="IDDOCUMENTO" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="NUMERO" Precision="0" ProviderType="Decimal" Scale="0" Size="22" SourceColumn="NUMERO" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="NUMEROLINEA" Precision="0" ProviderType="Decimal" Scale="0" Size="22" SourceColumn="NUMEROLINEA" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="IDPLAN" Precision="0" ProviderType="Varchar2" Scale="0" Size="5" SourceColumn="IDPLAN" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="IMEI" Precision="0" ProviderType="Varchar2" Scale="0" Size="20" SourceColumn="IMEI" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="ICCID" Precision="0" ProviderType="Varchar2" Scale="0" Size="20" SourceColumn="ICCID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="MIND" Precision="0" ProviderType="Varchar2" Scale="0" Size="20" SourceColumn="MIND" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="VALOR" Precision="0" ProviderType="Decimal" Scale="0" Size="22" SourceColumn="VALOR" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="ANTICIPO" Precision="0" ProviderType="Decimal" Scale="0" Size="22" SourceColumn="ANTICIPO" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="ACTIVO" Precision="0" ProviderType="Char" Scale="0" Size="1" SourceColumn="ACTIVO" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="VALORBASEIMEI" Precision="0" ProviderType="Decimal" Scale="0" Size="22" SourceColumn="VALORBASEIMEI" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="VALORIVAIMEI" Precision="0" ProviderType="Decimal" Scale="0" Size="22" SourceColumn="VALORIVAIMEI" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="VALORBASEICCID" Precision="0" ProviderType="Decimal" Scale="0" Size="22" SourceColumn="VALORBASEICCID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="VALORIVAICCID" Precision="0" ProviderType="Decimal" Scale="0" Size="22" SourceColumn="VALORIVAICCID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="IDPRODUCTOIMEI" Precision="0" ProviderType="Varchar2" Scale="0" Size="15" SourceColumn="IDPRODUCTOIMEI" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="IDPRODUCTOICCID" Precision="0" ProviderType="Varchar2" Scale="0" Size="15" SourceColumn="IDPRODUCTOICCID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_IDDOCUMENTO" Precision="0" ProviderType="Varchar2" Scale="0" Size="5" SourceColumn="IDDOCUMENTO" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="Original_NUMERO" Precision="0" ProviderType="Decimal" Scale="0" Size="22" SourceColumn="NUMERO" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="Original_NUMEROLINEA" Precision="0" ProviderType="Decimal" Scale="0" Size="22" SourceColumn="NUMEROLINEA" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_IDPLAN" Precision="0" ProviderType="Varchar2" Scale="0" Size="5" SourceColumn="IDPLAN" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_IMEI" Precision="0" ProviderType="Int32" Scale="0" Size="20" SourceColumn="IMEI" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_IMEI" Precision="0" ProviderType="Varchar2" Scale="0" Size="20" SourceColumn="IMEI" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_ICCID" Precision="0" ProviderType="Int32" Scale="0" Size="20" SourceColumn="ICCID" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_ICCID" Precision="0" ProviderType="Varchar2" Scale="0" Size="20" SourceColumn="ICCID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_MIND" Precision="0" ProviderType="Int32" Scale="0" Size="20" SourceColumn="MIND" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_MIND" Precision="0" ProviderType="Varchar2" Scale="0" Size="20" SourceColumn="MIND" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_VALOR" Precision="0" ProviderType="Int32" Scale="0" Size="22" SourceColumn="VALOR" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="Original_VALOR" Precision="0" ProviderType="Decimal" Scale="0" Size="22" SourceColumn="VALOR" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_ANTICIPO" Precision="0" ProviderType="Int32" Scale="0" Size="22" SourceColumn="ANTICIPO" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="Original_ANTICIPO" Precision="0" ProviderType="Decimal" Scale="0" Size="22" SourceColumn="ANTICIPO" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_ACTIVO" Precision="0" ProviderType="Int32" Scale="0" Size="1" SourceColumn="ACTIVO" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="Original_ACTIVO" Precision="0" ProviderType="Char" Scale="0" Size="1" SourceColumn="ACTIVO" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="Original_VALORBASEIMEI" Precision="0" ProviderType="Decimal" Scale="0" Size="22" SourceColumn="VALORBASEIMEI" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="Original_VALORIVAIMEI" Precision="0" ProviderType="Decimal" Scale="0" Size="22" SourceColumn="VALORIVAIMEI" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="Original_VALORBASEICCID" Precision="0" ProviderType="Decimal" Scale="0" Size="22" SourceColumn="VALORBASEICCID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="Original_VALORIVAICCID" Precision="0" ProviderType="Decimal" Scale="0" Size="22" SourceColumn="VALORIVAICCID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_IDPRODUCTOIMEI" Precision="0" ProviderType="Int32" Scale="0" Size="15" SourceColumn="IDPRODUCTOIMEI" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_IDPRODUCTOIMEI" Precision="0" ProviderType="Varchar2" Scale="0" Size="15" SourceColumn="IDPRODUCTOIMEI" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_IDPRODUCTOICCID" Precision="0" ProviderType="Int32" Scale="0" Size="15" SourceColumn="IDPRODUCTOICCID" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_IDPRODUCTOICCID" Precision="0" ProviderType="Varchar2" Scale="0" Size="15" SourceColumn="IDPRODUCTOICCID" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="IDDOCUMENTO" DataSetColumn="IDDOCUMENTO" />
              <Mapping SourceColumn="NUMERO" DataSetColumn="NUMERO" />
              <Mapping SourceColumn="NUMEROLINEA" DataSetColumn="NUMEROLINEA" />
              <Mapping SourceColumn="IDPLAN" DataSetColumn="IDPLAN" />
              <Mapping SourceColumn="IMEI" DataSetColumn="IMEI" />
              <Mapping SourceColumn="ICCID" DataSetColumn="ICCID" />
              <Mapping SourceColumn="MIND" DataSetColumn="MIND" />
              <Mapping SourceColumn="VALOR" DataSetColumn="VALOR" />
              <Mapping SourceColumn="ANTICIPO" DataSetColumn="ANTICIPO" />
              <Mapping SourceColumn="ACTIVO" DataSetColumn="ACTIVO" />
              <Mapping SourceColumn="VALORBASEIMEI" DataSetColumn="VALORBASEIMEI" />
              <Mapping SourceColumn="VALORIVAIMEI" DataSetColumn="VALORIVAIMEI" />
              <Mapping SourceColumn="VALORBASEICCID" DataSetColumn="VALORBASEICCID" />
              <Mapping SourceColumn="VALORIVAICCID" DataSetColumn="VALORIVAICCID" />
              <Mapping SourceColumn="IDPRODUCTOIMEI" DataSetColumn="IDPRODUCTOIMEI" />
              <Mapping SourceColumn="IDPRODUCTOICCID" DataSetColumn="IDPRODUCTOICCID" />
            </Mappings>
            <Sources>
              <DbSource ConnectionRef="ConnectionString (MySettings)" DbObjectName="SAMUEL.MOV_PLANDETALLE" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="FillByIdDocumentoNumero" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetDataByIdDocumentoNumero" GeneratorSourceName="FillByIdDocumentoNumero" GetMethodModifier="Public" GetMethodName="GetDataByIdDocumentoNumero" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataByIdDocumentoNumero" UserSourceName="FillByIdDocumentoNumero">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT ACTIVO, ANTICIPO, ICCID, IDDOCUMENTO, IDPLAN, IDPRODUCTOICCID, IDPRODUCTOIMEI, IMEI, MIND, NUMERO, NUMEROLINEA, VALOR, VALORBASEICCID, VALORBASEIMEI, VALORIVAICCID, VALORIVAIMEI FROM MOV_PLANDETALLE WHERE (IDDOCUMENTO = :PIDDOCUMENTO) AND (NUMERO = :PNUMERO)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="PIDDOCUMENTO" ColumnName="IDDOCUMENTO" DataSourceName="" DataTypeServer="NVARCHAR2(5)" DbType="String" Direction="Input" ParameterName=":PIDDOCUMENTO" Precision="0" ProviderType="Varchar2" Scale="0" Size="5" SourceColumn="IDDOCUMENTO" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="PNUMERO" ColumnName="NUMERO" DataSourceName="" DataTypeServer="NUMBER(22)" DbType="Decimal" Direction="Input" ParameterName=":PNUMERO" Precision="38" ProviderType="Decimal" Scale="0" Size="22" SourceColumn="NUMERO" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </Sources>
          </TableAdapter>
        </Tables>
        <Sources />
      </DataSource>
    </xs:appinfo>
  </xs:annotation>
  <xs:element name="dsMovimiento" msdata:IsDataSet="true" msdata:UseCurrentLocale="true" msprop:Generator_UserDSName="dsMovimiento" msprop:Generator_DataSetName="dsMovimiento" msprop:EnableTableAdapterManager="true">
    <xs:complexType>
      <xs:choice minOccurs="0" maxOccurs="unbounded">
        <xs:element name="MOV_MOVIMIENTO" msprop:Generator_UserTableName="MOV_MOVIMIENTO" msprop:Generator_RowDeletedName="MOV_MOVIMIENTORowDeleted" msprop:Generator_RowChangedName="MOV_MOVIMIENTORowChanged" msprop:Generator_RowClassName="MOV_MOVIMIENTORow" msprop:Generator_RowChangingName="MOV_MOVIMIENTORowChanging" msprop:Generator_RowEvArgName="MOV_MOVIMIENTORowChangeEvent" msprop:Generator_RowEvHandlerName="MOV_MOVIMIENTORowChangeEventHandler" msprop:Generator_TableClassName="MOV_MOVIMIENTODataTable" msprop:Generator_TableVarName="tableMOV_MOVIMIENTO" msprop:Generator_RowDeletingName="MOV_MOVIMIENTORowDeleting" msprop:Generator_TablePropName="MOV_MOVIMIENTO">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="IDDOCUMENTO" msprop:Generator_UserColumnName="IDDOCUMENTO" msprop:Generator_ColumnVarNameInTable="columnIDDOCUMENTO" msprop:Generator_ColumnPropNameInRow="IDDOCUMENTO" msprop:Generator_ColumnPropNameInTable="IDDOCUMENTOColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="5" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="NUMERO" msprop:Generator_UserColumnName="NUMERO" msprop:Generator_ColumnVarNameInTable="columnNUMERO" msprop:Generator_ColumnPropNameInRow="NUMERO" msprop:Generator_ColumnPropNameInTable="NUMEROColumn" type="xs:decimal" />
              <xs:element name="ANULADO" msprop:Generator_UserColumnName="ANULADO" msprop:Generator_ColumnVarNameInTable="columnANULADO" msprop:Generator_ColumnPropNameInRow="ANULADO" msprop:Generator_ColumnPropNameInTable="ANULADOColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="1" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="FECHADOCUMENTO" msprop:Generator_UserColumnName="FECHADOCUMENTO" msprop:Generator_ColumnVarNameInTable="columnFECHADOCUMENTO" msprop:Generator_ColumnPropNameInRow="FECHADOCUMENTO" msprop:Generator_ColumnPropNameInTable="FECHADOCUMENTOColumn" type="xs:dateTime" minOccurs="0" />
              <xs:element name="FECHAVENCIMIENTO" msprop:Generator_UserColumnName="FECHAVENCIMIENTO" msprop:Generator_ColumnVarNameInTable="columnFECHAVENCIMIENTO" msprop:Generator_ColumnPropNameInRow="FECHAVENCIMIENTO" msprop:Generator_ColumnPropNameInTable="FECHAVENCIMIENTOColumn" type="xs:dateTime" minOccurs="0" />
              <xs:element name="IDBODEGADESTINO" msprop:Generator_UserColumnName="IDBODEGADESTINO" msprop:Generator_ColumnVarNameInTable="columnIDBODEGADESTINO" msprop:Generator_ColumnPropNameInRow="IDBODEGADESTINO" msprop:Generator_ColumnPropNameInTable="IDBODEGADESTINOColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="5" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="IDBODEGAORIGEN" msprop:Generator_UserColumnName="IDBODEGAORIGEN" msprop:Generator_ColumnVarNameInTable="columnIDBODEGAORIGEN" msprop:Generator_ColumnPropNameInRow="IDBODEGAORIGEN" msprop:Generator_ColumnPropNameInTable="IDBODEGAORIGENColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="5" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="IDCANAL" msprop:Generator_UserColumnName="IDCANAL" msprop:Generator_ColumnVarNameInTable="columnIDCANAL" msprop:Generator_ColumnPropNameInRow="IDCANAL" msprop:Generator_ColumnPropNameInTable="IDCANALColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="5" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="IDCCOSTO" msprop:Generator_UserColumnName="IDCCOSTO" msprop:Generator_ColumnVarNameInTable="columnIDCCOSTO" msprop:Generator_ColumnPropNameInRow="IDCCOSTO" msprop:Generator_ColumnPropNameInTable="IDCCOSTOColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="5" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="IDDOCREFERENCIA" msprop:Generator_UserColumnName="IDDOCREFERENCIA" msprop:Generator_ColumnVarNameInTable="columnIDDOCREFERENCIA" msprop:Generator_ColumnPropNameInRow="IDDOCREFERENCIA" msprop:Generator_ColumnPropNameInTable="IDDOCREFERENCIAColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="5" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="IDLISTA" msprop:Generator_UserColumnName="IDLISTA" msprop:Generator_ColumnVarNameInTable="columnIDLISTA" msprop:Generator_ColumnPropNameInRow="IDLISTA" msprop:Generator_ColumnPropNameInTable="IDLISTAColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="5" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="IDSEDE" msprop:Generator_UserColumnName="IDSEDE" msprop:Generator_ColumnVarNameInTable="columnIDSEDE" msprop:Generator_ColumnPropNameInRow="IDSEDE" msprop:Generator_ColumnPropNameInTable="IDSEDEColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="5" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="IDTERCERO" msprop:Generator_UserColumnName="IDTERCERO" msprop:Generator_ColumnVarNameInTable="columnIDTERCERO" msprop:Generator_ColumnPropNameInRow="IDTERCERO" msprop:Generator_ColumnPropNameInTable="IDTERCEROColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="15" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="IDVENDEDOR" msprop:Generator_UserColumnName="IDVENDEDOR" msprop:Generator_ColumnVarNameInTable="columnIDVENDEDOR" msprop:Generator_ColumnPropNameInRow="IDVENDEDOR" msprop:Generator_ColumnPropNameInTable="IDVENDEDORColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="15" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="IMPRESO" msprop:Generator_UserColumnName="IMPRESO" msprop:Generator_ColumnVarNameInTable="columnIMPRESO" msprop:Generator_ColumnPropNameInRow="IMPRESO" msprop:Generator_ColumnPropNameInTable="IMPRESOColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="1" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="NOTA" msprop:Generator_UserColumnName="NOTA" msprop:Generator_ColumnVarNameInTable="columnNOTA" msprop:Generator_ColumnPropNameInRow="NOTA" msprop:Generator_ColumnPropNameInTable="NOTAColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="30" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="NUMEROREFERENCIA" msprop:Generator_UserColumnName="NUMEROREFERENCIA" msprop:Generator_ColumnVarNameInTable="columnNUMEROREFERENCIA" msprop:Generator_ColumnPropNameInRow="NUMEROREFERENCIA" msprop:Generator_ColumnPropNameInTable="NUMEROREFERENCIAColumn" type="xs:decimal" minOccurs="0" />
              <xs:element name="SALDO" msprop:Generator_UserColumnName="SALDO" msprop:Generator_ColumnVarNameInTable="columnSALDO" msprop:Generator_ColumnPropNameInRow="SALDO" msprop:Generator_ColumnPropNameInTable="SALDOColumn" type="xs:decimal" minOccurs="0" />
              <xs:element name="VALORBASE" msprop:Generator_UserColumnName="VALORBASE" msprop:Generator_ColumnVarNameInTable="columnVALORBASE" msprop:Generator_ColumnPropNameInRow="VALORBASE" msprop:Generator_ColumnPropNameInTable="VALORBASEColumn" type="xs:decimal" default="0" minOccurs="0" />
              <xs:element name="VALORIVA" msprop:Generator_UserColumnName="VALORIVA" msprop:Generator_ColumnVarNameInTable="columnVALORIVA" msprop:Generator_ColumnPropNameInRow="VALORIVA" msprop:Generator_ColumnPropNameInTable="VALORIVAColumn" type="xs:decimal" default="0" minOccurs="0" />
              <xs:element name="VALORPAGOS" msprop:Generator_UserColumnName="VALORPAGOS" msprop:Generator_ColumnVarNameInTable="columnVALORPAGOS" msprop:Generator_ColumnPropNameInRow="VALORPAGOS" msprop:Generator_ColumnPropNameInTable="VALORPAGOSColumn" type="xs:decimal" default="0" minOccurs="0" />
              <xs:element name="VALORRETENCION" msprop:Generator_UserColumnName="VALORRETENCION" msprop:Generator_ColumnVarNameInTable="columnVALORRETENCION" msprop:Generator_ColumnPropNameInRow="VALORRETENCION" msprop:Generator_ColumnPropNameInTable="VALORRETENCIONColumn" type="xs:decimal" default="0" minOccurs="0" />
              <xs:element name="SUCURSAL" msprop:Generator_UserColumnName="SUCURSAL" msprop:Generator_ColumnVarNameInTable="columnSUCURSAL" msprop:Generator_ColumnPropNameInRow="SUCURSAL" msprop:Generator_ColumnPropNameInTable="SUCURSALColumn" type="xs:decimal" minOccurs="0" />
              <xs:element name="IDFORMAPAGO" msprop:Generator_UserColumnName="IDFORMAPAGO" msprop:Generator_ColumnVarNameInTable="columnIDFORMAPAGO" msprop:Generator_ColumnPropNameInRow="IDFORMAPAGO" msprop:Generator_ColumnPropNameInTable="IDFORMAPAGOColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="5" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="NOFACCOMCEL" msprop:Generator_UserColumnName="NOFACCOMCEL" msprop:Generator_ColumnVarNameInTable="columnNOFACCOMCEL" msprop:Generator_ColumnPropNameInRow="NOFACCOMCEL" msprop:Generator_ColumnPropNameInTable="NOFACCOMCELColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="15" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="IDCAJA" msprop:Generator_UserColumnName="IDCAJA" msprop:Generator_ColumnVarNameInTable="columnIDCAJA" msprop:Generator_ColumnPropNameInRow="IDCAJA" msprop:Generator_ColumnPropNameInTable="IDCAJAColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="3" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="IDCENTROSUMI" msprop:Generator_UserColumnName="IDCENTROSUMI" msprop:Generator_ColumnVarNameInTable="columnIDCENTROSUMI" msprop:Generator_ColumnPropNameInRow="IDCENTROSUMI" msprop:Generator_ColumnPropNameInTable="IDCENTROSUMIColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="10" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="NOREMCOMCEL" msprop:Generator_UserColumnName="NOREMCOMCEL" msprop:Generator_ColumnVarNameInTable="columnNOREMCOMCEL" msprop:Generator_ColumnPropNameInRow="NOREMCOMCEL" msprop:Generator_ColumnPropNameInTable="NOREMCOMCELColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="15" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="MOV_MOVIMIENTODETALLE" msprop:Generator_UserTableName="MOV_MOVIMIENTODETALLE" msprop:Generator_RowDeletedName="MOV_MOVIMIENTODETALLERowDeleted" msprop:Generator_RowChangedName="MOV_MOVIMIENTODETALLERowChanged" msprop:Generator_RowClassName="MOV_MOVIMIENTODETALLERow" msprop:Generator_RowChangingName="MOV_MOVIMIENTODETALLERowChanging" msprop:Generator_RowEvArgName="MOV_MOVIMIENTODETALLERowChangeEvent" msprop:Generator_RowEvHandlerName="MOV_MOVIMIENTODETALLERowChangeEventHandler" msprop:Generator_TableClassName="MOV_MOVIMIENTODETALLEDataTable" msprop:Generator_TableVarName="tableMOV_MOVIMIENTODETALLE" msprop:Generator_RowDeletingName="MOV_MOVIMIENTODETALLERowDeleting" msprop:Generator_TablePropName="MOV_MOVIMIENTODETALLE">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="IDDOCUMENTO" msprop:Generator_UserColumnName="IDDOCUMENTO" msprop:Generator_ColumnVarNameInTable="columnIDDOCUMENTO" msprop:Generator_ColumnPropNameInRow="IDDOCUMENTO" msprop:Generator_ColumnPropNameInTable="IDDOCUMENTOColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="5" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="NUMERO" msprop:Generator_UserColumnName="NUMERO" msprop:Generator_ColumnVarNameInTable="columnNUMERO" msprop:Generator_ColumnPropNameInRow="NUMERO" msprop:Generator_ColumnPropNameInTable="NUMEROColumn" type="xs:decimal" />
              <xs:element name="NUMEROLINEA" msprop:Generator_UserColumnName="NUMEROLINEA" msprop:Generator_ColumnVarNameInTable="columnNUMEROLINEA" msprop:Generator_ColumnPropNameInRow="NUMEROLINEA" msprop:Generator_ColumnPropNameInTable="NUMEROLINEAColumn" type="xs:decimal" />
              <xs:element name="IDPRODUCTO" msprop:Generator_UserColumnName="IDPRODUCTO" msprop:Generator_ColumnVarNameInTable="columnIDPRODUCTO" msprop:Generator_ColumnPropNameInRow="IDPRODUCTO" msprop:Generator_ColumnPropNameInTable="IDPRODUCTOColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="15" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="IDIVA" msprop:Generator_UserColumnName="IDIVA" msprop:Generator_ColumnVarNameInTable="columnIDIVA" msprop:Generator_ColumnPropNameInRow="IDIVA" msprop:Generator_ColumnPropNameInTable="IDIVAColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="5" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="CANTIDAD" msprop:Generator_UserColumnName="CANTIDAD" msprop:Generator_ColumnVarNameInTable="columnCANTIDAD" msprop:Generator_ColumnPropNameInRow="CANTIDAD" msprop:Generator_ColumnPropNameInTable="CANTIDADColumn" type="xs:decimal" default="0" minOccurs="0" />
              <xs:element name="DESCUENTO1" msprop:Generator_UserColumnName="DESCUENTO1" msprop:Generator_ColumnVarNameInTable="columnDESCUENTO1" msprop:Generator_ColumnPropNameInRow="DESCUENTO1" msprop:Generator_ColumnPropNameInTable="DESCUENTO1Column" type="xs:decimal" default="0" minOccurs="0" />
              <xs:element name="DESCUENTO2" msprop:Generator_UserColumnName="DESCUENTO2" msprop:Generator_ColumnVarNameInTable="columnDESCUENTO2" msprop:Generator_ColumnPropNameInRow="DESCUENTO2" msprop:Generator_ColumnPropNameInTable="DESCUENTO2Column" type="xs:decimal" default="0" minOccurs="0" />
              <xs:element name="VALORBASE" msprop:Generator_UserColumnName="VALORBASE" msprop:Generator_ColumnVarNameInTable="columnVALORBASE" msprop:Generator_ColumnPropNameInRow="VALORBASE" msprop:Generator_ColumnPropNameInTable="VALORBASEColumn" type="xs:decimal" default="0" minOccurs="0" />
              <xs:element name="VALORIVA" msprop:Generator_UserColumnName="VALORIVA" msprop:Generator_ColumnVarNameInTable="columnVALORIVA" msprop:Generator_ColumnPropNameInRow="VALORIVA" msprop:Generator_ColumnPropNameInTable="VALORIVAColumn" type="xs:decimal" default="0" minOccurs="0" />
              <xs:element name="VALORLINEA" msdata:ReadOnly="true" msdata:Expression="(VALORBASE*CANTIDAD*(1-DESCUENTO1)*(1-DESCUENTO2))+(VALORIVA*CANTIDAD*(1-DESCUENTO1)*(1-DESCUENTO2))" msprop:Generator_UserColumnName="VALORLINEA" msprop:Generator_ColumnVarNameInTable="columnVALORLINEA" msprop:Generator_ColumnPropNameInRow="VALORLINEA" msprop:Generator_ColumnPropNameInTable="VALORLINEAColumn" type="xs:decimal" default="0" minOccurs="0" />
              <xs:element name="IDTIPOLISTA" msprop:Generator_UserColumnName="IDTIPOLISTA" msprop:Generator_ColumnVarNameInTable="columnIDTIPOLISTA" msprop:Generator_ColumnPropNameInRow="IDTIPOLISTA" msprop:Generator_ColumnPropNameInTable="IDTIPOLISTAColumn" type="xs:decimal" minOccurs="0" />
              <xs:element name="IDPREPACK" msprop:Generator_UserColumnName="IDPREPACK" msprop:Generator_ColumnVarNameInTable="columnIDPREPACK" msprop:Generator_ColumnPropNameInRow="IDPREPACK" msprop:Generator_ColumnPropNameInTable="IDPREPACKColumn" type="xs:decimal" minOccurs="0" />
              <xs:element name="IDPRODDESTINO" msprop:Generator_UserColumnName="IDPRODDESTINO" msprop:Generator_ColumnVarNameInTable="columnIDPRODDESTINO" msprop:Generator_ColumnPropNameInRow="IDPRODDESTINO" msprop:Generator_ColumnPropNameInTable="IDPRODDESTINOColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="15" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="NUMEROLINEAPADRE" msprop:Generator_UserColumnName="NUMEROLINEAPADRE" msprop:Generator_ColumnVarNameInTable="columnNUMEROLINEAPADRE" msprop:Generator_ColumnPropNameInRow="NUMEROLINEAPADRE" msprop:Generator_ColumnPropNameInTable="NUMEROLINEAPADREColumn" type="xs:decimal" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="MOV_DESCRIPCIONDET" msprop:Generator_UserTableName="MOV_DESCRIPCIONDET" msprop:Generator_RowDeletedName="MOV_DESCRIPCIONDETRowDeleted" msprop:Generator_RowChangedName="MOV_DESCRIPCIONDETRowChanged" msprop:Generator_RowClassName="MOV_DESCRIPCIONDETRow" msprop:Generator_RowChangingName="MOV_DESCRIPCIONDETRowChanging" msprop:Generator_RowEvArgName="MOV_DESCRIPCIONDETRowChangeEvent" msprop:Generator_RowEvHandlerName="MOV_DESCRIPCIONDETRowChangeEventHandler" msprop:Generator_TableClassName="MOV_DESCRIPCIONDETDataTable" msprop:Generator_TableVarName="tableMOV_DESCRIPCIONDET" msprop:Generator_RowDeletingName="MOV_DESCRIPCIONDETRowDeleting" msprop:Generator_TablePropName="MOV_DESCRIPCIONDET">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="IDDOCUMENTO" msprop:Generator_UserColumnName="IDDOCUMENTO" msprop:Generator_ColumnVarNameInTable="columnIDDOCUMENTO" msprop:Generator_ColumnPropNameInRow="IDDOCUMENTO" msprop:Generator_ColumnPropNameInTable="IDDOCUMENTOColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="5" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="NUMERO" msprop:Generator_UserColumnName="NUMERO" msprop:Generator_ColumnVarNameInTable="columnNUMERO" msprop:Generator_ColumnPropNameInRow="NUMERO" msprop:Generator_ColumnPropNameInTable="NUMEROColumn" type="xs:decimal" />
              <xs:element name="NUMEROLINEA" msprop:Generator_UserColumnName="NUMEROLINEA" msprop:Generator_ColumnVarNameInTable="columnNUMEROLINEA" msprop:Generator_ColumnPropNameInRow="NUMEROLINEA" msprop:Generator_ColumnPropNameInTable="NUMEROLINEAColumn" type="xs:decimal" />
              <xs:element name="IDPRODUCTO" msprop:Generator_UserColumnName="IDPRODUCTO" msprop:Generator_ColumnVarNameInTable="columnIDPRODUCTO" msprop:Generator_ColumnPropNameInRow="IDPRODUCTO" msprop:Generator_ColumnPropNameInTable="IDPRODUCTOColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="15" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="TIPOSUBPROD" msprop:Generator_UserColumnName="TIPOSUBPROD" msprop:Generator_ColumnVarNameInTable="columnTIPOSUBPROD" msprop:Generator_ColumnPropNameInRow="TIPOSUBPROD" msprop:Generator_ColumnPropNameInTable="TIPOSUBPRODColumn" type="xs:decimal" />
              <xs:element name="NUMEROREGISTRO" msprop:Generator_UserColumnName="NUMEROREGISTRO" msprop:Generator_ColumnVarNameInTable="columnNUMEROREGISTRO" msprop:Generator_ColumnPropNameInRow="NUMEROREGISTRO" msprop:Generator_ColumnPropNameInTable="NUMEROREGISTROColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="20" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="NUMEROPRODUCTO" msprop:Generator_UserColumnName="NUMEROPRODUCTO" msprop:Generator_ColumnVarNameInTable="columnNUMEROPRODUCTO" msprop:Generator_ColumnPropNameInRow="NUMEROPRODUCTO" msprop:Generator_ColumnPropNameInTable="NUMEROPRODUCTOColumn" type="xs:decimal" minOccurs="0" />
              <xs:element name="COSTO" msprop:Generator_UserColumnName="COSTO" msprop:Generator_ColumnVarNameInTable="columnCOSTO" msprop:Generator_ColumnPropNameInRow="COSTO" msprop:Generator_ColumnPropNameInTable="COSTOColumn" type="xs:decimal" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="MOV_DETALLENOTASCREDITO" msprop:Generator_UserTableName="MOV_DETALLENOTASCREDITO" msprop:Generator_RowDeletedName="MOV_DETALLENOTASCREDITORowDeleted" msprop:Generator_RowChangedName="MOV_DETALLENOTASCREDITORowChanged" msprop:Generator_RowClassName="MOV_DETALLENOTASCREDITORow" msprop:Generator_RowChangingName="MOV_DETALLENOTASCREDITORowChanging" msprop:Generator_RowEvArgName="MOV_DETALLENOTASCREDITORowChangeEvent" msprop:Generator_RowEvHandlerName="MOV_DETALLENOTASCREDITORowChangeEventHandler" msprop:Generator_TableClassName="MOV_DETALLENOTASCREDITODataTable" msprop:Generator_TableVarName="tableMOV_DETALLENOTASCREDITO" msprop:Generator_RowDeletingName="MOV_DETALLENOTASCREDITORowDeleting" msprop:Generator_TablePropName="MOV_DETALLENOTASCREDITO">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="IDDOCUMENTO" msprop:Generator_UserColumnName="IDDOCUMENTO" msprop:Generator_ColumnVarNameInTable="columnIDDOCUMENTO" msprop:Generator_ColumnPropNameInRow="IDDOCUMENTO" msprop:Generator_ColumnPropNameInTable="IDDOCUMENTOColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="5" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="NUMERO" msprop:Generator_UserColumnName="NUMERO" msprop:Generator_ColumnVarNameInTable="columnNUMERO" msprop:Generator_ColumnPropNameInRow="NUMERO" msprop:Generator_ColumnPropNameInTable="NUMEROColumn" type="xs:decimal" />
              <xs:element name="NUMEROLINEA" msprop:Generator_UserColumnName="NUMEROLINEA" msprop:Generator_ColumnVarNameInTable="columnNUMEROLINEA" msprop:Generator_ColumnPropNameInRow="NUMEROLINEA" msprop:Generator_ColumnPropNameInTable="NUMEROLINEAColumn" type="xs:decimal" />
              <xs:element name="IDDOCFACTURA" msprop:Generator_UserColumnName="IDDOCFACTURA" msprop:Generator_ColumnVarNameInTable="columnIDDOCFACTURA" msprop:Generator_ColumnPropNameInRow="IDDOCFACTURA" msprop:Generator_ColumnPropNameInTable="IDDOCFACTURAColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="5" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="NUMEROFACTURA" msprop:Generator_UserColumnName="NUMEROFACTURA" msprop:Generator_ColumnVarNameInTable="columnNUMEROFACTURA" msprop:Generator_ColumnPropNameInRow="NUMEROFACTURA" msprop:Generator_ColumnPropNameInTable="NUMEROFACTURAColumn" type="xs:decimal" minOccurs="0" />
              <xs:element name="VALORNOTA" msprop:Generator_UserColumnName="VALORNOTA" msprop:Generator_ColumnVarNameInTable="columnVALORNOTA" msprop:Generator_ColumnPropNameInRow="VALORNOTA" msprop:Generator_ColumnPropNameInTable="VALORNOTAColumn" type="xs:decimal" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="MOV_DETALLENOTASDEBITO" msprop:Generator_UserTableName="MOV_DETALLENOTASDEBITO" msprop:Generator_RowDeletedName="MOV_DETALLENOTASDEBITORowDeleted" msprop:Generator_RowChangedName="MOV_DETALLENOTASDEBITORowChanged" msprop:Generator_RowClassName="MOV_DETALLENOTASDEBITORow" msprop:Generator_RowChangingName="MOV_DETALLENOTASDEBITORowChanging" msprop:Generator_RowEvArgName="MOV_DETALLENOTASDEBITORowChangeEvent" msprop:Generator_RowEvHandlerName="MOV_DETALLENOTASDEBITORowChangeEventHandler" msprop:Generator_TableClassName="MOV_DETALLENOTASDEBITODataTable" msprop:Generator_TableVarName="tableMOV_DETALLENOTASDEBITO" msprop:Generator_RowDeletingName="MOV_DETALLENOTASDEBITORowDeleting" msprop:Generator_TablePropName="MOV_DETALLENOTASDEBITO">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="IDDOCUMENTO" msprop:Generator_UserColumnName="IDDOCUMENTO" msprop:Generator_ColumnVarNameInTable="columnIDDOCUMENTO" msprop:Generator_ColumnPropNameInRow="IDDOCUMENTO" msprop:Generator_ColumnPropNameInTable="IDDOCUMENTOColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="5" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="NUMERO" msprop:Generator_UserColumnName="NUMERO" msprop:Generator_ColumnVarNameInTable="columnNUMERO" msprop:Generator_ColumnPropNameInRow="NUMERO" msprop:Generator_ColumnPropNameInTable="NUMEROColumn" type="xs:decimal" />
              <xs:element name="NUMEROLINEA" msprop:Generator_UserColumnName="NUMEROLINEA" msprop:Generator_ColumnVarNameInTable="columnNUMEROLINEA" msprop:Generator_ColumnPropNameInRow="NUMEROLINEA" msprop:Generator_ColumnPropNameInTable="NUMEROLINEAColumn" type="xs:decimal" />
              <xs:element name="IDPRODUCTO" msprop:Generator_UserColumnName="IDPRODUCTO" msprop:Generator_ColumnVarNameInTable="columnIDPRODUCTO" msprop:Generator_ColumnPropNameInRow="IDPRODUCTO" msprop:Generator_ColumnPropNameInTable="IDPRODUCTOColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="15" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="TIPOSUBPROD" msprop:Generator_UserColumnName="TIPOSUBPROD" msprop:Generator_ColumnVarNameInTable="columnTIPOSUBPROD" msprop:Generator_ColumnPropNameInRow="TIPOSUBPROD" msprop:Generator_ColumnPropNameInTable="TIPOSUBPRODColumn" type="xs:decimal" minOccurs="0" />
              <xs:element name="NUMEROREGISTRO" msprop:Generator_UserColumnName="NUMEROREGISTRO" msprop:Generator_ColumnVarNameInTable="columnNUMEROREGISTRO" msprop:Generator_ColumnPropNameInRow="NUMEROREGISTRO" msprop:Generator_ColumnPropNameInTable="NUMEROREGISTROColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="20" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="COSTOCOMPRA" msprop:Generator_UserColumnName="COSTOCOMPRA" msprop:Generator_ColumnVarNameInTable="columnCOSTOCOMPRA" msprop:Generator_ColumnPropNameInRow="COSTOCOMPRA" msprop:Generator_ColumnPropNameInTable="COSTOCOMPRAColumn" type="xs:decimal" minOccurs="0" />
              <xs:element name="COSTOCOMCEL" msprop:Generator_UserColumnName="COSTOCOMCEL" msprop:Generator_ColumnVarNameInTable="columnCOSTOCOMCEL" msprop:Generator_ColumnPropNameInRow="COSTOCOMCEL" msprop:Generator_ColumnPropNameInTable="COSTOCOMCELColumn" type="xs:decimal" minOccurs="0" />
              <xs:element name="DIFERENCIA" msprop:Generator_UserColumnName="DIFERENCIA" msprop:Generator_ColumnVarNameInTable="columnDIFERENCIA" msprop:Generator_ColumnPropNameInRow="DIFERENCIA" msprop:Generator_ColumnPropNameInTable="DIFERENCIAColumn" type="xs:decimal" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="MOV_PLAN" msprop:Generator_UserTableName="MOV_PLAN" msprop:Generator_RowDeletedName="MOV_PLANRowDeleted" msprop:Generator_RowChangedName="MOV_PLANRowChanged" msprop:Generator_RowClassName="MOV_PLANRow" msprop:Generator_RowChangingName="MOV_PLANRowChanging" msprop:Generator_RowEvArgName="MOV_PLANRowChangeEvent" msprop:Generator_RowEvHandlerName="MOV_PLANRowChangeEventHandler" msprop:Generator_TableClassName="MOV_PLANDataTable" msprop:Generator_TableVarName="tableMOV_PLAN" msprop:Generator_RowDeletingName="MOV_PLANRowDeleting" msprop:Generator_TablePropName="MOV_PLAN">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="IDDOCUMENTO" msprop:Generator_UserColumnName="IDDOCUMENTO" msprop:Generator_ColumnVarNameInTable="columnIDDOCUMENTO" msprop:Generator_ColumnPropNameInRow="IDDOCUMENTO" msprop:Generator_ColumnPropNameInTable="IDDOCUMENTOColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="5" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="NUMERO" msprop:Generator_UserColumnName="NUMERO" msprop:Generator_ColumnVarNameInTable="columnNUMERO" msprop:Generator_ColumnPropNameInRow="NUMERO" msprop:Generator_ColumnPropNameInTable="NUMEROColumn" type="xs:decimal" />
              <xs:element name="FECHADOCUMENTO" msprop:Generator_UserColumnName="FECHADOCUMENTO" msprop:Generator_ColumnVarNameInTable="columnFECHADOCUMENTO" msprop:Generator_ColumnPropNameInRow="FECHADOCUMENTO" msprop:Generator_ColumnPropNameInTable="FECHADOCUMENTOColumn" type="xs:dateTime" minOccurs="0" />
              <xs:element name="IDCANAL" msprop:Generator_UserColumnName="IDCANAL" msprop:Generator_ColumnVarNameInTable="columnIDCANAL" msprop:Generator_ColumnPropNameInRow="IDCANAL" msprop:Generator_ColumnPropNameInTable="IDCANALColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="5" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="IDCCOSTO" msprop:Generator_UserColumnName="IDCCOSTO" msprop:Generator_ColumnVarNameInTable="columnIDCCOSTO" msprop:Generator_ColumnPropNameInRow="IDCCOSTO" msprop:Generator_ColumnPropNameInTable="IDCCOSTOColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="5" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="IDLISTA" msprop:Generator_UserColumnName="IDLISTA" msprop:Generator_ColumnVarNameInTable="columnIDLISTA" msprop:Generator_ColumnPropNameInRow="IDLISTA" msprop:Generator_ColumnPropNameInTable="IDLISTAColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="5" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="IDSEDE" msprop:Generator_UserColumnName="IDSEDE" msprop:Generator_ColumnVarNameInTable="columnIDSEDE" msprop:Generator_ColumnPropNameInRow="IDSEDE" msprop:Generator_ColumnPropNameInTable="IDSEDEColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="5" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="IDTERCERO" msprop:Generator_UserColumnName="IDTERCERO" msprop:Generator_ColumnVarNameInTable="columnIDTERCERO" msprop:Generator_ColumnPropNameInRow="IDTERCERO" msprop:Generator_ColumnPropNameInTable="IDTERCEROColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="15" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="SUCURSAL" msprop:Generator_UserColumnName="SUCURSAL" msprop:Generator_ColumnVarNameInTable="columnSUCURSAL" msprop:Generator_ColumnPropNameInRow="SUCURSAL" msprop:Generator_ColumnPropNameInTable="SUCURSALColumn" type="xs:decimal" minOccurs="0" />
              <xs:element name="IDFORMAPAGO" msprop:Generator_UserColumnName="IDFORMAPAGO" msprop:Generator_ColumnVarNameInTable="columnIDFORMAPAGO" msprop:Generator_ColumnPropNameInRow="IDFORMAPAGO" msprop:Generator_ColumnPropNameInTable="IDFORMAPAGOColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="5" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="IDCAJA" msprop:Generator_UserColumnName="IDCAJA" msprop:Generator_ColumnVarNameInTable="columnIDCAJA" msprop:Generator_ColumnPropNameInRow="IDCAJA" msprop:Generator_ColumnPropNameInTable="IDCAJAColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="5" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="IDBODEGAORIGEN" msprop:Generator_UserColumnName="IDBODEGAORIGEN" msprop:Generator_ColumnVarNameInTable="columnIDBODEGAORIGEN" msprop:Generator_ColumnPropNameInRow="IDBODEGAORIGEN" msprop:Generator_ColumnPropNameInTable="IDBODEGAORIGENColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="5" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="IDVENDEDOR" msprop:Generator_UserColumnName="IDVENDEDOR" msprop:Generator_ColumnVarNameInTable="columnIDVENDEDOR" msprop:Generator_ColumnPropNameInRow="IDVENDEDOR" msprop:Generator_ColumnPropNameInTable="IDVENDEDORColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="15" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="MOV_PLANDETALLE" msprop:Generator_UserTableName="MOV_PLANDETALLE" msprop:Generator_RowDeletedName="MOV_PLANDETALLERowDeleted" msprop:Generator_RowChangedName="MOV_PLANDETALLERowChanged" msprop:Generator_RowClassName="MOV_PLANDETALLERow" msprop:Generator_RowChangingName="MOV_PLANDETALLERowChanging" msprop:Generator_RowEvArgName="MOV_PLANDETALLERowChangeEvent" msprop:Generator_RowEvHandlerName="MOV_PLANDETALLERowChangeEventHandler" msprop:Generator_TableClassName="MOV_PLANDETALLEDataTable" msprop:Generator_TableVarName="tableMOV_PLANDETALLE" msprop:Generator_RowDeletingName="MOV_PLANDETALLERowDeleting" msprop:Generator_TablePropName="MOV_PLANDETALLE">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="IDDOCUMENTO" msprop:Generator_UserColumnName="IDDOCUMENTO" msprop:Generator_ColumnVarNameInTable="columnIDDOCUMENTO" msprop:Generator_ColumnPropNameInRow="IDDOCUMENTO" msprop:Generator_ColumnPropNameInTable="IDDOCUMENTOColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="5" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="NUMERO" msprop:Generator_UserColumnName="NUMERO" msprop:Generator_ColumnVarNameInTable="columnNUMERO" msprop:Generator_ColumnPropNameInRow="NUMERO" msprop:Generator_ColumnPropNameInTable="NUMEROColumn" type="xs:decimal" />
              <xs:element name="NUMEROLINEA" msprop:Generator_UserColumnName="NUMEROLINEA" msprop:Generator_ColumnVarNameInTable="columnNUMEROLINEA" msprop:Generator_ColumnPropNameInRow="NUMEROLINEA" msprop:Generator_ColumnPropNameInTable="NUMEROLINEAColumn" type="xs:decimal" />
              <xs:element name="IDPLAN" msprop:Generator_UserColumnName="IDPLAN" msprop:Generator_ColumnVarNameInTable="columnIDPLAN" msprop:Generator_ColumnPropNameInRow="IDPLAN" msprop:Generator_ColumnPropNameInTable="IDPLANColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="5" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="IMEI" msprop:Generator_UserColumnName="IMEI" msprop:Generator_ColumnVarNameInTable="columnIMEI" msprop:Generator_ColumnPropNameInRow="IMEI" msprop:Generator_ColumnPropNameInTable="IMEIColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="20" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="ICCID" msprop:Generator_UserColumnName="ICCID" msprop:Generator_ColumnVarNameInTable="columnICCID" msprop:Generator_ColumnPropNameInRow="ICCID" msprop:Generator_ColumnPropNameInTable="ICCIDColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="20" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="MIND" msprop:Generator_UserColumnName="MIND" msprop:Generator_ColumnVarNameInTable="columnMIND" msprop:Generator_ColumnPropNameInRow="MIND" msprop:Generator_ColumnPropNameInTable="MINDColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="20" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="VALOR" msprop:Generator_UserColumnName="VALOR" msprop:Generator_ColumnVarNameInTable="columnVALOR" msprop:Generator_ColumnPropNameInRow="VALOR" msprop:Generator_ColumnPropNameInTable="VALORColumn" type="xs:decimal" default="0" minOccurs="0" />
              <xs:element name="ANTICIPO" msprop:Generator_UserColumnName="ANTICIPO" msprop:Generator_ColumnVarNameInTable="columnANTICIPO" msprop:Generator_ColumnPropNameInRow="ANTICIPO" msprop:Generator_ColumnPropNameInTable="ANTICIPOColumn" type="xs:decimal" default="0" minOccurs="0" />
              <xs:element name="ACTIVO" msprop:Generator_UserColumnName="ACTIVO" msprop:Generator_ColumnVarNameInTable="columnACTIVO" msprop:Generator_ColumnPropNameInRow="ACTIVO" msprop:Generator_ColumnPropNameInTable="ACTIVOColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="1" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="VALORBASEIMEI" msprop:Generator_UserColumnName="VALORBASEIMEI" msprop:Generator_ColumnPropNameInRow="VALORBASEIMEI" msprop:Generator_ColumnVarNameInTable="columnVALORBASEIMEI" msprop:Generator_ColumnPropNameInTable="VALORBASEIMEIColumn" type="xs:decimal" />
              <xs:element name="VALORIVAIMEI" msprop:Generator_UserColumnName="VALORIVAIMEI" msprop:Generator_ColumnPropNameInRow="VALORIVAIMEI" msprop:Generator_ColumnVarNameInTable="columnVALORIVAIMEI" msprop:Generator_ColumnPropNameInTable="VALORIVAIMEIColumn" type="xs:decimal" />
              <xs:element name="VALORBASEICCID" msprop:Generator_UserColumnName="VALORBASEICCID" msprop:Generator_ColumnPropNameInRow="VALORBASEICCID" msprop:Generator_ColumnVarNameInTable="columnVALORBASEICCID" msprop:Generator_ColumnPropNameInTable="VALORBASEICCIDColumn" type="xs:decimal" />
              <xs:element name="VALORIVAICCID" msprop:Generator_UserColumnName="VALORIVAICCID" msprop:Generator_ColumnPropNameInRow="VALORIVAICCID" msprop:Generator_ColumnVarNameInTable="columnVALORIVAICCID" msprop:Generator_ColumnPropNameInTable="VALORIVAICCIDColumn" type="xs:decimal" />
              <xs:element name="IDPRODUCTOIMEI" msprop:Generator_UserColumnName="IDPRODUCTOIMEI" msprop:Generator_ColumnVarNameInTable="columnIDPRODUCTOIMEI" msprop:Generator_ColumnPropNameInRow="IDPRODUCTOIMEI" msprop:Generator_ColumnPropNameInTable="IDPRODUCTOIMEIColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="15" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="IDPRODUCTOICCID" msprop:Generator_UserColumnName="IDPRODUCTOICCID" msprop:Generator_ColumnVarNameInTable="columnIDPRODUCTOICCID" msprop:Generator_ColumnPropNameInRow="IDPRODUCTOICCID" msprop:Generator_ColumnPropNameInTable="IDPRODUCTOICCIDColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="15" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
      </xs:choice>
    </xs:complexType>
    <xs:unique name="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:MOV_MOVIMIENTO" />
      <xs:field xpath="mstns:IDDOCUMENTO" />
      <xs:field xpath="mstns:NUMERO" />
    </xs:unique>
    <xs:unique name="MOV_MOVIMIENTODETALLE_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:MOV_MOVIMIENTODETALLE" />
      <xs:field xpath="mstns:IDDOCUMENTO" />
      <xs:field xpath="mstns:NUMERO" />
      <xs:field xpath="mstns:NUMEROLINEA" />
    </xs:unique>
    <xs:unique name="Constraint2">
      <xs:selector xpath=".//mstns:MOV_MOVIMIENTODETALLE" />
      <xs:field xpath="mstns:IDDOCUMENTO" />
      <xs:field xpath="mstns:NUMERO" />
      <xs:field xpath="mstns:NUMEROLINEA" />
      <xs:field xpath="mstns:IDPRODUCTO" />
    </xs:unique>
    <xs:unique name="MOV_DESCRIPCIONDET_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:MOV_DESCRIPCIONDET" />
      <xs:field xpath="mstns:IDDOCUMENTO" />
      <xs:field xpath="mstns:NUMERO" />
      <xs:field xpath="mstns:NUMEROLINEA" />
      <xs:field xpath="mstns:IDPRODUCTO" />
      <xs:field xpath="mstns:TIPOSUBPROD" />
      <xs:field xpath="mstns:NUMEROREGISTRO" />
    </xs:unique>
    <xs:unique name="MOV_DETALLENOTASCREDITO_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:MOV_DETALLENOTASCREDITO" />
      <xs:field xpath="mstns:IDDOCUMENTO" />
      <xs:field xpath="mstns:NUMERO" />
      <xs:field xpath="mstns:NUMEROLINEA" />
    </xs:unique>
    <xs:unique name="MOV_DETALLENOTASDEBITO_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:MOV_DETALLENOTASDEBITO" />
      <xs:field xpath="mstns:IDDOCUMENTO" />
      <xs:field xpath="mstns:NUMERO" />
      <xs:field xpath="mstns:NUMEROLINEA" />
      <xs:field xpath="mstns:IDPRODUCTO" />
    </xs:unique>
    <xs:unique name="MOV_PLAN_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:MOV_PLAN" />
      <xs:field xpath="mstns:IDDOCUMENTO" />
      <xs:field xpath="mstns:NUMERO" />
    </xs:unique>
    <xs:unique name="MOV_PLANDETALLE_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:MOV_PLANDETALLE" />
      <xs:field xpath="mstns:IDDOCUMENTO" />
      <xs:field xpath="mstns:NUMERO" />
      <xs:field xpath="mstns:NUMEROLINEA" />
      <xs:field xpath="mstns:IDPLAN" />
    </xs:unique>
    <xs:keyref name="FK_MOV_MOVIMIENTO_MOV_DETALLENOTASDEBITO" refer="Constraint1" msprop:rel_Generator_UserRelationName="FK_MOV_MOVIMIENTO_MOV_DETALLENOTASDEBITO" msprop:rel_Generator_RelationVarName="relationFK_MOV_MOVIMIENTO_MOV_DETALLENOTASDEBITO" msprop:rel_Generator_UserChildTable="MOV_DETALLENOTASDEBITO" msprop:rel_Generator_UserParentTable="MOV_MOVIMIENTO" msprop:rel_Generator_ParentPropName="MOV_MOVIMIENTORowParent" msprop:rel_Generator_ChildPropName="GetMOV_DETALLENOTASDEBITORows">
      <xs:selector xpath=".//mstns:MOV_DETALLENOTASDEBITO" />
      <xs:field xpath="mstns:IDDOCUMENTO" />
      <xs:field xpath="mstns:NUMERO" />
    </xs:keyref>
    <xs:keyref name="FK_MOV_MOVIMIENTO_MOV_DETALLENOTASCREDITO" refer="Constraint1" msprop:rel_Generator_UserRelationName="FK_MOV_MOVIMIENTO_MOV_DETALLENOTASCREDITO" msprop:rel_Generator_RelationVarName="relationFK_MOV_MOVIMIENTO_MOV_DETALLENOTASCREDITO" msprop:rel_Generator_UserChildTable="MOV_DETALLENOTASCREDITO" msprop:rel_Generator_UserParentTable="MOV_MOVIMIENTO" msprop:rel_Generator_ParentPropName="MOV_MOVIMIENTORowParent" msprop:rel_Generator_ChildPropName="GetMOV_DETALLENOTASCREDITORows">
      <xs:selector xpath=".//mstns:MOV_DETALLENOTASCREDITO" />
      <xs:field xpath="mstns:IDDOCUMENTO" />
      <xs:field xpath="mstns:NUMERO" />
    </xs:keyref>
    <xs:keyref name="FK_MOV_MOVIMIENTODETALLE_MOV_DESCRIPCIONDET" refer="Constraint2" msprop:rel_Generator_UserRelationName="FK_MOV_MOVIMIENTODETALLE_MOV_DESCRIPCIONDET" msprop:rel_Generator_RelationVarName="relationFK_MOV_MOVIMIENTODETALLE_MOV_DESCRIPCIONDET" msprop:rel_Generator_UserChildTable="MOV_DESCRIPCIONDET" msprop:rel_Generator_UserParentTable="MOV_MOVIMIENTODETALLE" msprop:rel_Generator_ParentPropName="MOV_MOVIMIENTODETALLERowParent" msprop:rel_Generator_ChildPropName="GetMOV_DESCRIPCIONDETRows">
      <xs:selector xpath=".//mstns:MOV_DESCRIPCIONDET" />
      <xs:field xpath="mstns:IDDOCUMENTO" />
      <xs:field xpath="mstns:NUMERO" />
      <xs:field xpath="mstns:NUMEROLINEA" />
      <xs:field xpath="mstns:IDPRODUCTO" />
    </xs:keyref>
    <xs:keyref name="FK_MOV_MOVIMIENTO_MOV_MOVIMIENTODETALLE" refer="Constraint1" msprop:rel_Generator_UserRelationName="FK_MOV_MOVIMIENTO_MOV_MOVIMIENTODETALLE" msprop:rel_Generator_RelationVarName="relationFK_MOV_MOVIMIENTO_MOV_MOVIMIENTODETALLE" msprop:rel_Generator_UserChildTable="MOV_MOVIMIENTODETALLE" msprop:rel_Generator_UserParentTable="MOV_MOVIMIENTO" msprop:rel_Generator_ParentPropName="MOV_MOVIMIENTORowParent" msprop:rel_Generator_ChildPropName="GetMOV_MOVIMIENTODETALLERows">
      <xs:selector xpath=".//mstns:MOV_MOVIMIENTODETALLE" />
      <xs:field xpath="mstns:IDDOCUMENTO" />
      <xs:field xpath="mstns:NUMERO" />
    </xs:keyref>
  </xs:element>
  <xs:annotation>
    <xs:appinfo>
      <msdata:Relationship name="FK_PLANDETALLE_PLAN" msdata:parent="MOV_PLAN" msdata:child="MOV_PLANDETALLE" msdata:parentkey="IDDOCUMENTO NUMERO" msdata:childkey="IDDOCUMENTO NUMERO" msprop:Generator_UserRelationName="FK_PLANDETALLE_PLAN" msprop:Generator_RelationVarName="relationFK_PLANDETALLE_PLAN" msprop:Generator_UserChildTable="MOV_PLANDETALLE" msprop:Generator_UserParentTable="MOV_PLAN" msprop:Generator_ParentPropName="MOV_PLANRowParent" msprop:Generator_ChildPropName="GetMOV_PLANDETALLERows" />
    </xs:appinfo>
  </xs:annotation>
</xs:schema>